Have you looked at this article?

http://www.oracle.com/technology/oramag/oracle/04-sep/o54data.html


-----Original Message-----
From: O Donnell Kevin
[mailto:oracledba-ezmlmshield-x38247066.[Email address protected]
Sent: Thursday, May 05, 2005 10:46 AM
To: LazyDBA Discussion
Subject: Schema Copy

Hello All

I am looking for some options on replicating/duplicating one schema to
another. I know i can use imp and exp, although do to the size of the
database the process will take about 8 hours.

Does anyone know of any other options for duplicating a schema on the
same instance?

Thanks

Kevin O'Donnell
Sr. Database Administrator
Neighborcare Technology Center


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page