Load Data through External Tables in Oracle

Q

How To Load Data through External Tables in Oracle?

✍: FYIcenter.com

A

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, 239👍, 0💬