Basic Oracle Concepts and Programming Question:
How To Load Data through External Tables?
Answer:
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.
► 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.
| Previous Question | Next Question |
| What Is an External Table? | What Are the Restrictions on External Table Columns? |