OraFAQ Forum: Server Utilities » hot to copy all data to a new schema

Members

Help

Home

Home » RDBMS Server » Server Utilities » hot to copy all data to a new schema

Show: Today's Messages :: Show Polls :: Message Navigator

E-mail to friend

hot to copy all data to a new schema [message #428917]

Fri, 30 October 2009 14:25

miroconnect@yahoo.com
Messages: 85
Registered: April 2006

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 ?

Report message to a moderator