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

How to Export/Import Table Using Toad

        On the Schema browser select the table
        Right click on the table and select “Export Data”

        Set the output file format and path and set the data substitution as per the requirement.
        Same as the export to import data either right click on selected table and select “import data” or from the database menu select import->import Table data.

        After setting proper schema/object/object to be import press “Next
        Now select the source file type (either Excel/Text/DBF) and file location.

First Row: 2 ignore the first row in the excel i.e column heading.
Last row: 18000 maximum limit of row to be imported.
Same as you can set the date/time and number
        In the “Next” Click it prompts to indicate column mapping from source to destination.
        Verify the mapping and press OK.


Post a Comment