| |
 |
|
Oracle Tips by Burleson |
Chapter 8 General Oracle Auditing
--
-- Free for non-commercial use.
-- For commercial licensing, e-mail info@rampant.cc
--
-- *********************************************
# -------------------------------------------------------
# Filename : archive_audit_1.sh
# Description : First part of the AUD$ archival and purge
# process.
# Parameters : 1. 2-digit Year of the archival process
# 2. 2-digit Month of the process
# Important:
# Change the variables AUDIT_TS_NAME and
# ARC_FILE_SYSTEM, SYS_PASSWORD to suit to your site.
# -------------------------------------------------------
#
# Site dependent variables
AUDIT_TS_NAME=SYSTEM
ARC_FILE_SYSTEM=/u201
SYS_PASSWORD=manager
#
ARC_YEAR=$1
ARC_MONTH=$2
ARC_TS_NAME=AUD$ARC_YEAR$ARC_MONTH
ARC_TABLE_NAME=AUD$ARC_YEAR$ARC_MONTH
#
sqlplus /nolog << EOF1
whenever sqlerror exit
connect sys/$SYS_PASSWORD as sysdba
create tablespace $ARC_TS_NAME
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
|
|
