Create Credentials and Load Data Pump Dump Files into an Existing Table
For data loading you can also use Oracle Data Pump dump files as source files.
The source files for this load type 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 load the data you first move the dump files that were exported using the
ORACLE_DATAPUMP
access driver to your Object Store and then use DBMS_CLOUD.COPY_DATA
to load the dump files to an
existing table in your database.
The source files in this example are the Oracle Data Pump dump files,
exp01.dmp
and exp02.dmp
.
Parent topic: Load Data from Files in the Cloud