RE: Full database export as user ' / as sysdba'

From: Jesse, Rich <Rich.Jesse_at_quadtechworld.com>
Date: Wed, 29 Sep 2004 11:13:51 -0500
Message-ID: <FBE1FCA40ECAD41180400050DA2BC54004E93DC7@qtiexch2.qgraph.com>

Hey Scott,
What was in the .aud file? Each object imported/exported, or rows, or what? Do you have AUDIT statement(s) set? And what do you have the init.ora param AUDIT_TRAIL set to?

Just curious...

Thx!
Rich

-----Original Message-----

Sent: Wednesday, September 29, 2004 10:45 AM Subject: Re: Full database export as user ' / as sysdba'

I can think of one:

If you implement audit_sys_operations=TRUE in 9i (per security requirements, etc), you can end up with some _HUGE_ .aud files. Had this one bite us when we upgraded to 9.2.0.5.

--Scott

--

http://www.freelists.org/webpage/oracle-l Received on Wed Sep 29 2004 - 11:11:05 CDT