 |
|
Oracle Tips by Burleson |
Chapter 8 General Oracle Auditing
#
exp transport_tablespace=Y tablespaces=\($ARC_TS_NAME\) file=$ARC_FILE_SYSTEM/tts_${ARC_TS_NAME}.dmp
< .sys_passwd
#
echo AudArch: Exported Tablesapce as Transportable
echo Files $ARC_FILE_SYSTEM/tts_${ARC_TS_NAME}.dmp and $ARC_FILE_SYSTEM/${ARCH_TS_NAME}_01.dbf
should be put together and form a set.
echo Only after this part is over successfully, run the
echo Part 3 of the process.
#
# End of Script
At this stage the tablespace can be dropped.
archive_audit_3.sh
--**********************************************
--
--
Copyright © 2003 by Rampant TechPress Inc.
--
-- Free for
non-commercial use.
-- For
commercial licensing, e-mail info@rampant.cc
--
--
*********************************************
#
-------------------------------------------------------
# Filename
: archive_audit_3.sh
# Description
: Third part of the AUD$ archival and
# purge process.
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
|
|