Re: upgrade question
From: Phillip Jones <phil_at_phillip.im>
Date: Tue, 6 Mar 2012 15:15:32 +0000
Message-ID: <CAOyzJufUg3OAHhFtj=s5kT1bgd=w2jNizBKy0O3HyVGXMbVo8w_at_mail.gmail.com>
I think this is because of the new DBMS_AUDIT_MGMT package. It sets the default tablespace for audit tables to SYSTEM. You can verify this by looking in the dba_audit_mgmt_config_params view on a fresh 11g database. Once you've upgraded you can move the tables back using DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION.
Date: Tue, 6 Mar 2012 15:15:32 +0000
Message-ID: <CAOyzJufUg3OAHhFtj=s5kT1bgd=w2jNizBKy0O3HyVGXMbVo8w_at_mail.gmail.com>
I think this is because of the new DBMS_AUDIT_MGMT package. It sets the default tablespace for audit tables to SYSTEM. You can verify this by looking in the dba_audit_mgmt_config_params view on a fresh 11g database. Once you've upgraded you can move the tables back using DBMS_AUDIT_MGMT.SET_AUDIT_TRAIL_LOCATION.
Cheers,
Phil
On Tue, Mar 6, 2012 at 2:56 PM, Sheehan, Jeremy < JEREMY.SHEEHAN_at_nexteraenergy.com> wrote:
> Just curious about this, but what is the reason that the AUD$ table needs
> to be moved from SYSAUX to SYSTEM prior to an upgrade? For us, it
> currently resides in the SYSAUX tablespace. I'm looking over the 10g - 11g
> manual upgrade checklist
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Mar 06 2012 - 09:15:32 CST