Re: Copying Schema's

From: Pestilence <adonis__at_hotmail.com>
Date: Thu, 29 Mar 2001 22:32:39 GMT
Message-ID: <bKOw6.175449$t67.2820826@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 - 16:32:39 CST