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.
Now check data 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.
Now check data in the destination schema.


A87838E8
ReplyDeleteSur
Osmangazi
Yeşilyurt
Boyabat
Döşemealtı
Çiğli
Sivrihisar
Körfez
Turgutreis
19730D97
ReplyDeleteAyaş
Kulu
Kandıra
Çivril
Gökçeada
Elbistan
Şehitkamil
Kuşadası
Ceyhan