Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: exp/imp sys/system
OOPs the role is called
exp_full_database
Fingers got away from me... sorry.
"Steve Ashmore" <sashmore_at_neonramp.com> wrote in message
news:udjfldoo71ep18_at_corp.supernews.com...
> There shouldn't be.
> But you should be careful which ID's you use. The convention is not to use
> sys for anything except at install
> and upgrade time.
> Most shops do not use system either. They create a third ID and grant it
> DBA.
>
> To be extra secure you may even wish to create another ID and grant it
> export full database
> and use it for your full export.
>
> Stephen C. Ashmore
> Brainbench MVP for Oracle Administration
> http://www.brainbench.com
>
> Author of: 'So You Want to be an Oracle DBA?'
>
>
> "Thomas Beetz" <t.beetz_at_web.de> wrote in message
> news:3CD8CD45.8170370_at_web.de...
> > Hello,
> >
> > is there a difference between a full export import as system or as
> > sys,
> >
> > Thanks Thomas
> >
>
>
Received on Wed May 08 2002 - 19:30:58 CDT