Home » SQL & PL/SQL » SQL & PL/SQL » Coping database objects from one schema to another - Urgent Please help
Coping database objects from one schema to another - Urgent Please help [message #35741] Thu, 11 October 2001 06:43 Go to next message
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.

----------------------------------------------------------------------
Re: Coping database objects from one schema to another - Urgent Please help [message #35743 is a reply to message #35741] Thu, 11 October 2001 09:52 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
The best way is to use the exp/imp (export/import) commands. They are run on the server and allow you to easily export a schema and import it into a different schema.

----------------------------------------------------------------------
Previous Topic: To find one row before & after all retrieved rows
Next Topic: compiling a stored procedure
Goto Forum:
  


Current Time: Sat May 25 15:33:11 CDT 2024