Copy a Table from One Database to another Database using Toad

Copy a Table from One Database to another Database using Toad

–        One the Schema Browser Select the table to be copied.

–        Right Click on the Table and select “Create in another schema”

 

 

–        A dialog box appears, set the Common parameter as per the requirement and press OK

–        Next dialog box set the Destination connection and schema name (if you are able to connect both the DB through Toad) and press OK.

–        Finally a successful object creation message appears. Describe and check the table definition on destination.

Note: Do not forget to create related tablespace on the destination DB.

–        Now to copy data again right click on the source table schema browser and select “copy data to another schema” this time.

 

 

–        Set the destination connection/Schema and required parameter then press “Execute”

–        Here you have also option for Query using “where clause” to copy limited row.