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

Wow.
That one's a potential life-saver.
I didn't know it did that.  Just tested exp for a few
tables on my 9.2.0.4 Solaris, and sure 'nuf, out pops
a big .aud file.

Thanks for that one, Scott!

bb

--- Scott Shafer <shafster@xxxxxxxxx> wrote:

> AUDIT_TRAIL is set to DB, but the file contained
> every object exported
> as '/ as sysdba'.  It was ugly (filled a mount
> point).  The
> audit_sys_operations parameter has no effect on the
> audit trial
> itself.  It logs all sys actions to .aud files.
> 
> 
> 
> On Wed, 29 Sep 2004 11:13:51 -0500, Jesse, Rich
> <rich.jesse@xxxxxxxxxxxxxxxxx> wrote:
> > 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?
> >
> --
> http://www.freelists.org/webpage/oracle-l
> 

--
http://www.freelists.org/webpage/oracle-l

Other related posts: