Coping database objects from one schema to another - Urgent Please help [message #35741] |
Thu, 11 October 2001 06:43 |
David
Messages: 110 Registered: November 1998
|
Senior Member |
|
|
Hi all,
I have a question and I hope someone can help.
I need to generate new schemas automatically. I wrote PL/SQL procedure using DBMS_SQL package. Basically I created a new user, grant it some privilages and then created all table based on the schema I want to copy from (basically create table as ...)
My question is, what do I do about the triggers, indexes, constraints etc ?
Am I on the right track or should I do something else?
I need to generate automatically all database object in one schema to another one.
Thanks.
----------------------------------------------------------------------
|
|
|
|