Re: Copying Schema's

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 29 Mar 2001 20:15:18 +0200
Message-ID: <tc710vpn2cutcf@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 - 12:15:18 CST