Databases Reference
In-Depth Information
The Export and Import Data Pump utilities allow us to easily transport data between Oracle
databases, even on different platforms. In our example we have exported two tables in a file,
but we can export a schema or the whole database.
In step 13 we use the command line utility Import Data Pump (
impdp
) to import the data and
metadata exported above in the database.
If you are not the schema owner, the
EXP_FULL_DATABASE
privilege is needed.
In the following screenshot we can observe the output of the export process:
There's more...
SQL*Loader is a powerful command-line utility to load data into the database. However, the
external table solution gives us more freedom and a very easy way to access our flat file data
to load them in the database. Don't use external tables for purposes other than loading data
in the database, which is the reason why they were designed.
