copy schema [message #75546] |
Wed, 15 September 2004 11:54 |
kim
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 |
Ben
Messages: 48 Registered: January 2000
|
Member |
|
|
Kim,
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.
done.
in case of the second scenario, you may want to have the replication done.
cheers !
|
|
|