Query External Data Pump Dump Files
You can also query Oracle Data Pump dump files in the Cloud by creating an
external table using DBMS_CLOUD.CREATE_EXTERNAL_TABLE
.
The source files to create this type of external table must be exported from
the source system using the ORACLE_DATAPUMP
access driver in External
Tables. See Unloading and Loading Data with the ORACLE_DATAPUMP Access
Driver for details on exporting using the ORACLE_DATAPUMP
access
driver.
To create an external table you first move the Oracle Data Pump dump files that
were exported using the ORACLE_DATAPUMP
access driver to your Object Store
and then use DBMS_CLOUD.CREATE_EXTERNAL_TABLE
to create the external table.
The source files in this example are the Oracle Data Pump dump files,
exp01.dmp
and exp02.dmp
.
Parent topic: Query External Data with Autonomous Database