Copying data from one database to another

>>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:

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

Latest Articles