Home » Server Options » Replication » copy schema
copy schema [message #75546] Wed, 15 September 2004 11:54 Go to next message
Messages: 116
Registered: December 2001
Senior Member
How can I copy one schema to another with all objects?

Can I do it in one statemant?
Re: copy schema [message #75549 is a reply to message #75546] Tue, 21 September 2004 02:25 Go to previous message
Messages: 48
Registered: January 2000
Is this within one database or do you want to bring the object across to another database (distributed) ?

Within the same db (in case of scenario # 1):
1. export the user objects
2. import with the fromuser, touser parms.
in case of the second scenario, you may want to have the replication done.
cheers !
Previous Topic: What is Oracle's engine native Master
Next Topic: very urgent
Goto Forum:

Current Time: Mon Nov 29 16:06:30 CST 2021