 |
|
Oracle Tips by Burleson |
Chapter 8 General Oracle Auditing
create table
aud_0307
tablespace aud_arch_data
nologging
as
select * from aud$
/
This will create a table with minimal logging
in the desired tablespace.
Next, truncate the original table aud$.
truncate
table aud$;
The truncation of table aud$ is supported. It
is the only SYS owned object that can be manipulated by the user.
Truncation will reset the high water mark of the table.
Shutdown the database, change the
initialization file to reflect audit_trail = db and then restart.
The tablespace AUD_ARCH_DATA can be made
read-only now and be backed up only once.
alter table audit_arch_data read only
/
Since it is read-only, there is no need to make
subsequent backups.
It may not be necessary to keep this database
online. It is conceivable that this table can be exported and the
export file preserved.
Preservation in Archival Media
The above text is
an excerpt from
the bestselling book:
Oracle
Privacy Security Auditing.
It's only $39.95 and has an
download of working security scripts:
This is the only authoritative
book on Oracle Security, Oracle Privacy, and Oracle Auditing written
by two of the world’s leading Oracle Security experts.
This indispensable book is only $39.95 and has an
download of working security scripts:
http://rampant-books.com/book_2003_2_audit.htm
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
