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.

 

Restrictions on External Table Columns in Oracle

What Is an External Table in Oracle

Loading and Exporting Data in Oracle

⇑⇑ Oracle Database Tutorials

2016-11-27, 1704🔥, 0💬