Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: sys.aud$ not in sysaux tablespace by default - what gives?

Re: sys.aud$ not in sysaux tablespace by default - what gives?

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Fri, 19 Nov 2004 08:07:35 +0000 (GMT)
Message-ID: <20041119080735.48167.qmail@web86909.mail.ukl.yahoo.com>


<conjecture>
Most Oracle upgrades are mandated by conditions of "fixed time to upgrade independent of database size". Oracle doesn't know if you've got 100's of gig's of audit data so it would not be prudent to move it as part of the upgrade process, so it has to stay where it is (wherever that may be). </conjecture>

However, I agree that it should be supported to relocate to SYSAUX once a db is installed. Interestingly, one of the Metalink notes about pre-reqs for upgrade to 10 is to ensure AUD$ is in SYSTEM if auditing is enabled during the process.

hth
connor


Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions" ISBN: 1590592174 web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"


                

Moving house? Beach bar in Thailand? New Wardrobe? Win 10k with Yahoo! Mail to make your dream a reality. Get Yahoo! Mail www.yahoo.co.uk/10k
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 19 2004 - 02:03:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US