There is a TFTS script answering your questions.
Oracle stores audit trail records in the SYS.AUD$ base data dictionary
table. The problem is this table grows inside the SYSTEM tablespace
and must have records deleted from it or be truncated, otherwise it
takes up all the room in the system tablespace. This deleting and
truncating of the SYS.AUD$ table fragments the system tablespace.
This script allows a DBA to move SYS.AUD$ out of the SYSTEM
tablespace. By moving it out of system tablespace, control of the
table's size can be controlled without filling or fragmenting the
system tablespace.
1019377.6 TFTS: SCRIPT TO MOVE SYS.AUD$ TABLE OUT OF SYSTEM TABLE
soverby_at_nspr.com wrote in message <76rgp8$njp$1_at_nnrp1.dejanews.com>...
>Can/should one move auditing tables that contain audit info from the system
>tablespace? If so, what tables and how?
>
>I don't like the idea of putting data in the system tablespace that has
the
>potential of filling it up or fragmenting it.
>
>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Tue Jan 05 1999 - 02:30:33 CST
