RE: upgrade question

From: Sheehan, Jeremy <JEREMY.SHEEHAN_at_nexteraenergy.com>
Date: Tue, 6 Mar 2012 10:21:50 -0500
Message-ID: <C3F905167E081B418BFC63B8668D52FF20CAB1B82E_at_GOXEXVS03.fplu.fpl.com>

Makes sense. Thanks for the info!
Jeremy

From: Phillip Jones [mailto:phil_at_phillip.im] Sent: Tuesday, March 06, 2012 10:16 AM
To: Sheehan, Jeremy
Cc: ORACLE-L
Subject: Re: upgrade question

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<mailto: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-l

Received on Tue Mar 06 2012 - 09:21:50 CST

This message: [ Message body ]
Next message: Guenadi Jilevski: "Re: RMAN convert 5TB db on Linux (Little Endian) to AIX (Big Endian) - alternatives?"
Previous message: Taylor, Chris David: "RMAN convert 5TB db on Linux (Little Endian) to AIX (Big Endian) - alternatives?"
In reply to: Phillip Jones: "Re: upgrade question"
Next in thread: Subodh Deshpande: "Re: upgrade question"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message