RE: move sys.aud$

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Tue, 10 Oct 2000 08:59:38 -0700
Message-Id: <10645.118881@fatcity.com>

The Oracle documentation states:

The maximum size of the database audit trail (SYS.AUD$ table) is predetermined during database creation. By default, up to 99 extents, each 10K in size,
can be allocated for this table.You should not move SYS.AUD$ to another tablespace as a means of controlling the growth and size of the audit trail. However, you can modify the default storage parameters in SYS.AUD$.

Note:

Moving the SYS.AUD$ table out of the SYSTEM tablespace is not supported because the Oracle code makes implicit

assumptions about the data dictionary tables such as SYS.AUD$, which could cause problems with upgrades and

backup/recovery scenarios.

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu

-----Original Message-----
From: Shevtsov, Eduard [mailto:EShevtsov_at_flagship.ru] Sent: Tuesday, October 10, 2000 2:09 AM
To: 'Multiple recipients of list ORACLE-L'; 'oracledba_at_quickdoc.co.uk' Subject: move sys.aud$

Hi List

I'm looking for the right way to move aud$ from sys tablespace. Should I use export/import ?

Thanks in advance

If you're bored, then visit the list's website: http://www.lazydba.com (updated daily)
to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk Received on Tue Oct 10 2000 - 10:59:38 CDT