Join this Blog for direct reference of any post into your inbox. To join just click on "Join this Site" under "Follower" then Login with your Email.*** DECLARATION: I Maintain this Blog for Helping Myself While at Work and Welcome any body Needing Help!!!.*** CAUTION: Using any of the script from this Blog may contain at Own Risk. These scripts May or May not have been Tested.***

Tuesday, 16 October 2012

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.


Post a Comment