Note:
This step is not needed if you are
importing the data to an Autonomous Data
Warehouse database, to an Autonomous Transaction
Processing database, or to Autonomous JSON Database.
If you export directly to Object
Store using Oracle Data Pump, as shown in Move Data with Data Pump Export to Object Store, then the dump files on Object
Store show size 0. Oracle Data Pump divides each dump
file part into smaller chunks for faster uploads. The Oracle Cloud
Infrastructure Object Storage console shows multiple files for each dump file part that you
export. The size of the actual dump files will be displayed as zero
(0) and its related file chunks as 10mb or less. For
example:
exp01.dmp
exp01.dmp_aaaaaa
exp02.dmp
exp02.dmp_aaaaaa
Downloading the zero byte dump
file from the Oracle Cloud
Infrastructure console or using the Oracle Cloud
Infrastructure CLI will not give you the full dump files. To download the full
dump files from the Object Store, use a tool that supports Swift
such as curl, and provide your user login and Swift auth
token.
curl -O -v -X GET -u 'user1@example.com:auth_token' \
https://swiftobjectstorage.us-ashburn-1.oraclecloud.com/v1/namespace-string/bucketname/exp01.dmp
The cURL command does not support wildcards or
substitution characters in its URL. You need to use
multiple cURL commands to download the dump file set
from your Object Store. Alternatively, you can use a
script that supports substitution characters to
download all the dump files from your Object Store
in a single command. See How
To: Download all files from an export to object
store job in Autonomous Database using cURL
for an example.