How To Load Data through External Tables


How To Load Data through External Tables? - Oracle DBA FAQ - Loading and Exporting Data



If you have data stored in external files, you can load it to database through an external table by the steps below:

  • Create an external table with columns matching data fields in the external file.
  • Create a regular table with the same columns.
  • Run an INSERT INTO ... SELECT statement to load data from the external file to the regular table through the external table.

2007-04-30, 4580👍, 0💬