Press "Enter" to skip to content

9 Simple Steps to Import CSV into Oracle Table Using Toad

In Toad, follow these 9 simple steps to import CSV into Oracle Table.

Steps to Import CSV into Oracle Table Using Toad

1. Click on Database menu > Import > Import Table Data.

Import CSV into Oracle Table Using Toad

2. Select table name from Object Name drop-down list then click on Show Data. Then click Next.

load text file in Oracle using toad

3. Select Text file radio button and enter the file name and path using browse button, then click Next.

import data using toad

4. Select the Delimited radio button and select the Delimiter from Delimiter radio group and click on Next.

csv text in toad

5. Preview file data and click on Next.

csv data using toad

6. Verify the mappings and specify primary key if any, then click Next.

toad import data wizard

7. Preview the results and click on Next.

load csv wizard toad

8. Select One commit after all records from the Commit mode drop-down list and select any other options if required and click on Execute button.

final import in toad

9. Finally, you will get the Import Completed dialogue with the summary of information.

Import CSV into Oracle Table Using Toad

See Also:

  1. Import CSV data into Oracle Table Using Stored Procedure
  2. Import CSV data into Oracle Table Using SQL Loader
  3. SQL Loader Control File Examples