DBA GENESIS
Courses
Contact
Members
More
Need steps tp import data from CSV format into Oracle Database.
Steps to Import CSV into Oracle Table Using Toad
1. Click on Database menu > Import > Import Table Data.
2. Select table name from Object Name drop-down list then click on Show Data. Then click Next.
3. Select Text file radio button and enter the file name and path using browse button, then click Next.
4. Select the Delimited radio button and select the Delimiter from Delimiter radio group and click on Next.
5. Preview file data and click on Next.
6. Verify the mappings and specify primary key if any, then click Next.
7. Preview the results and click on Next.
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.
9. Finally, you will get the Import Completed dialogue with the summary of information.
Steps to Import CSV into Oracle Table Using Toad
1. Click on Database menu > Import > Import Table Data.
2. Select table name from Object Name drop-down list then click on Show Data. Then click Next.
3. Select Text file radio button and enter the file name and path using browse button, then click Next.
4. Select the Delimited radio button and select the Delimiter from Delimiter radio group and click on Next.
5. Preview file data and click on Next.
6. Verify the mappings and specify primary key if any, then click Next.
7. Preview the results and click on Next.
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.
9. Finally, you will get the Import Completed dialogue with the summary of information.