
13.3
Transportation Methods 361
Chapter 13
An empty external table can also be created using the appropriate CRE-
ATE TABLE statement, including column definitions. An INSERT . . .
SELECT statement can be used to load the data into the external table.
However, TYPE ORACLE_DATAPUMP, specifying the data pump driver,
must be used to dynamically create or load the table using CREATE
TABLE . . . SELECT or INSERT INTO . . . SELECT. The only way to
load data into an external table using the ORACLE_LOADER driver is to
load the rows into the text file itself—it cannot be created from within Ora-
cle Database using Oracle SQL statements.
Table metadata must also ...