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

Get the Free Newsletter!

Subscribe to Cloud Insider for top news, trends & analysis

Latest Articles