expdp admin/password@db2022adb_high \
filesize=5GB \
dumpfile=default_credential:https://namespace-string.objectstorage.us-ashburn-1.oci.customer-oci.com/n/namespace-string/b/bucketname/o/exp%U.dmp \
parallel=16 \
encryption_pwd_prompt=yes \
logfile=export.log \
directory=data_pump_dir
For dumpfile
, this
example uses the recommended URI format using OCI Dedicated
Endpoints for commercial realm (OC1). The
namespace-string
is the Oracle Cloud Infrastructure object storage namespace and
bucketname
is the bucket
name. See Object Storage
Dedicated Endpoints, Regions and
Availability Domains, and Understanding
Object Storage Namespaces for more
information.The default_credential
keyword in the
dumpfile
parameter is required.
For the best
export performance use the HIGH
database service for your export
connection and set the parallel
parameter
to one quarter the number of ECPUs (.25 x ECPU
count). If you are using OCPU compute model, set
the parallel parameter to the number of OCPUs (1 x OCPU
count).
For information on which database service name to connect to run Data Pump
Export, see Manage Concurrency and Priorities on Autonomous Database.
For the dump file URL format for different Cloud
Object Storage services, see DBMS_CLOUD URI Formats.
This example
shows the recommended parameters for exporting from Autonomous Database. For these expdp
parameters,
note the following:
-
The maximum filesize
parameter value is 10000MB for Oracle Cloud
Infrastructure Object Storage exports.
-
The maximum filesize
parameter value is 20GB for Oracle Cloud
Infrastructure Object Storage Classic exports.
-
If the specified filesize
is too large, the export
shows the error message:
ORA-17500: ODM err:ODM HTTP Request Entity Too Large
-
The directory
parameter specifies the directory
data_pump_dir
for the specified log file,
export.log
. See Access Log Files for Data Pump Export for more information.
Note:
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
If you import a file with the DBMS_CLOUD
procedures that support
the format
parameter type
with the
value 'datapump
', you only need to provide the
primary file name. The procedures that support the
'datapump
' format type automatically
discover and download the chunks.
When you use DBMS_CLOUD.DELETE_OBJECT
, the
procedure automatically discovers and deletes the chunks when the
procedure deletes the primary file.