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
Step2: Go to the Describe Objects Window (Place your cursor on Table and click F4 button)
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.
Step1: Go to Schema where your table data exists
Step2: Go to the Describe Objects Window (Place your cursor on Table and click F4 button)
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.
No comments:
Post a Comment