Home » RDBMS Server » Server Utilities » hot to copy all data to a new schema
hot to copy all data to a new schema [message #428917] Fri, 30 October 2009 14:25 Go to next message
Messages: 202
Registered: April 2006
Senior Member
We maintain two schemas one for development and one for testing

developers makes changes to development schema and every time before testing we drop the testing schema and recreate from development schema.We use small sql script which copies all object from one schema to other , I need help or suggestions in copying data, we have lot of infrastructure data and its hard to write in sql or script which populates this , so I looking for some way which copies data from schema to other , we have toad is there anything in toad which can do this or are there any scripts available to do this ?
Re: hot to copy all data to a new schema [message #428919 is a reply to message #428917] Fri, 30 October 2009 14:31 Go to previous message
Mahesh Rajendran
Messages: 10673
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Export and Import.
Search this forum/google for more details.
Previous Topic: How to use subquery in query parameter of exp command
Next Topic: ORA-24372: invalid object for describe
Goto Forum:

Current Time: Thu Jul 27 10:18:03 CDT 2017

Total time taken to generate the page: 0.05949 seconds