Go to the FreeLists Home Page Home Signup Help Login
 



Browse oracle-l: This Month's ArchiveMain Archive PageRelated postsPrevious by DateNext by Date

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

  • From: Barbara Baker <barbarabbaker@xxxxxxxxx>
  • To: shafster@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 30 Sep 2004 08:03:54 -0700 (PDT)
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:

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




  • [ Home | Signup | Help | Login | Archives | Lists ]

    All trademarks and copyrights within the FreeLists archives are owned by their respective owners.
    Everything else ©2008 Avenir Technologies, LLC.