Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: exp/imp sys/system

Re: exp/imp sys/system

From: Steve Ashmore <sashmore_at_neonramp.com>
Date: Wed, 8 May 2002 19:30:58 -0500
Message-ID: <udjgq5q9o0eacd@corp.supernews.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US