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_at_gmail.com> 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_at_quadtechworld.com> 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