Re: sys.AUD$ tables in 12c upgrade
From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Wed, 19 Oct 2016 09:37:54 +0200
Message-ID: <CALH8A93r+K=SgXsdSfnYhdt4Y2JKof_OiJiEMimCU0ohh0rzdg_at_mail.gmail.com>
Date: Wed, 19 Oct 2016 09:37:54 +0200
Message-ID: <CALH8A93r+K=SgXsdSfnYhdt4Y2JKof_OiJiEMimCU0ohh0rzdg_at_mail.gmail.com>
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_at_gmail.com>:
> 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 .
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Oct 19 2016 - 09:37:54 CEST