Re: Copying Schema's

You need to export the affected user with the exp(ort) command (name platform dependent, exp on Unix and on the newer versions of Oracle on NT) I don't have the exact syntax ready (which is documented in the Oracle server utilities manual), but you can of course always use exp <return>
answer the username password prompt (take system/...) provide a buffer size (usually 8192000)
provide a file name
answer 2 or U to the next question
and at a certain stage provide the username. Then you need to do
imp <username/password of user system>
file=<the file you created in the previous step> buffer=8192000 full=y fromuser=(oldusername) touser=(newusername) etc.
of course this is all documented in the Oracle Server Utilities manual.

Hth,

Sybrand Bakker , Oracle DBA

"Pestilence" <adonis__at_hotmail.com> wrote in message news:bKOw6.175449$t67.2820826_at_news1.rdc1.il.home.com...
> I'm sorry I very new to this. I am not exaclty following what you have
> written there.
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> news:tc710vpn2cutcf_at_beta-news.demon.nl...
> >
> > "Pestilence" <adonis__at_hotmail.com> wrote in message
> > news:HAKw6.174711$t67.2808506_at_news1.rdc1.il.home.com...
> > > What is an easy way to copy a schema within the same database???
 Using
 Toad
> > > or sql?
> > >
> > >
> >
> > export one single user with export
> > import it with fromuser = (olduser) touser=(newuser)
> > The newuser should exist before running imp.
> > Hth,
> >
> > Sybrand Bakker, Oracle DBA
> >
> >
> > Hth,
> > Sybrand Bakker, Oracle DBA
> >
> >
>
>
Received on Thu Mar 29 2001 - 23:14:19 CST