How to import a Flat/Text Data file into Oracle Database? (4223290)

How to import table data from flat file?

Follow the steps below to import data from a flat file. It is assumed that the table is already existing with or without data in your Oracle database.

1. Select Database | import | Table Data
2. Select the schema where the table was created
3. Select the table from the drop down list
4. Click Show Data button
5. Click Execute Wizard button and follow the on-screen instructions, in versions 9.6 and above, click on the Next button at the bottom of the window.