Importing and exporting data by TOAD(for oracle DB)

Inserting into database using Toad

When your Requirement is to import the data inside a database and you have your data in spreadsheet the below is very easy.


  • Oracle Database.
  • TOAD tool configured to database.

Importing data


Go to Database->Import -> Import table Data


Select the schema, Object Type and Object Name


Click Next , Select the File, Click Next, Specify the Source Data Details and check the excel sheets, Columns and then Execute



At last you will find Execute Button. Press It to add the rows

Exporting from database

Go to Toad Menu, Database-> Schema Browser



Select Schema, Table


After Selecting right click table name -> Export  Data -> Choose Destination and click Ok



You can also add a additional where clause to specify the rows.


You can also try Create Script which gives you the DDL Statements like(Create table )

Thank you for Reading…



About pacesettergraam

A good and realistic person

Posted on September 27, 2013, in Oracle, SQL/PLSQL and tagged , , , , , . Bookmark the permalink. Leave a comment.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: