Thursday, December 10, 2015

Copy Table Data from One Database to Another Database

Here we are using TOAD to  copy Table data from one DB (Instance) to another DB (Instance).
Step1: Go to Schema where your table data exists

How to copy Table data from one DB to another DB, askhareesh blog for Oracle Apps

Step2:  Go to the Describe Objects Window (Place your cursor on Table and click F4 button)
How to copy Table data from one DB to another DB, askhareesh blog for Oracle Apps

Click on Copy data to another schema.
Step3: Give the Destination Connection and Schema and click on Run button(Begin Copying Data). You should have same table name with the same columns in the destination schema.
How to copy Table data from one DB to another DB, askhareesh blog for Oracle Apps 
How to copy Table data from one DB to another DB, askhareesh blog for Oracle Apps



How to copy Table data from one DB to another DB, askhareesh blog for Oracle Apps

No comments:

Post a Comment