Re: sys.AUD$ tables in 12c upgrade

  • From: vanita sharma <dba.vanitasharma@xxxxxxxxx>
  • To: Martin Berger <martin.a.berger@xxxxxxxxx>
  • Date: Wed, 19 Oct 2016 13:34:10 +0530

Thanks Martin .

On 19 October 2016 at 13:07, Martin Berger <martin.a.berger@xxxxxxxxx>
wrote:

Yes, starting with 11.2 you can mote AUD$ to another tablespace
using DBMS_AUDIT_MGMT.set_audit_trail_location.
You can see a nice example in https://oracle-base.com/
articles/11g/auditing-enhancements-11gr2

hth
 Martin

2016-10-19 8:09 GMT+02:00 vanita sharma <dba.vanitasharma@xxxxxxxxx>:

Hi ,


As per the 12c  upgrade prerequisites  sys.AUD$ tables must be in SYS
schema and SYSTEM tablespace.Can we move theses tables to different
tablespace other then system/sysaux  after upgrade to 12c .






Other related posts: