Load Data through External Tables in Oracle


How To Load Data through External Tables in Oracle?

✍: FYIcenter.com


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.


Loading and Exporting Data in Oracle

⇒⇒Oracle Database Tutorials

2016-11-27, 462👍, 0💬