Copying data from one database to another

December 8, 2006



>>Script Language and Platform: Oracle
If you want to copy the data from one database to another having many tables and constraints, all you need is this script, which will first disable all the constraints, delete the prior data, then copy the data from any remote database and finally enable all the constraints on the table of that database.......all you need, is to have a table having names of all the tables and the corresponding constraints.

Author: anoop arora


Download Script:
copy_data.sql


Disclaimer: We hope that the information on these script pages is valuable to you. Your use of the information contained in these pages, however, is at your sole risk. All information on these pages is provided "as -is", without any warranty, whether express or implied, of its accuracy, completeness, or fitness for a particular purpose... Disclaimer Continued


Back to Database Journal Home








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers