Notes for Importing with Oracle Data Pump
Lists notes for importing with Oracle Data Pump.
-
For the best import performance use the
HIGH
database service for your import connection and set theparallel
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).See Manage Concurrency and Priorities on Autonomous Database for information on database service names.
-
You can also use Data Pump Import to import SODA collections on Autonomous Database. See Import SODA Collection Data Using Oracle Data Pump Version 19.6 or Later for more information.
-
When you perform Oracle Data Pump export to Object Storage with a Swift URI, you must use Swift credentials to import with Oracle Data Pump import. See Oracle Cloud Infrastructure Object Storage Swift URI Format for more information on Swift URIs.
See Export Your Existing Oracle Database Directly to Cloud Object Storage (Export with Credential Parameter) for more information.
-
When you perform Oracle Data Pump export to Object Storage with a native URI, you can import using either Swift credentials or Signing Key based Credentials. See Oracle Cloud Infrastructure Object Storage Native URI Format for more information on Native URIs.
See Export Your Existing Oracle Database Directly to Cloud Object Storage (Export with Credential Parameter) for more information.
-
You must use a multiple step process to export with Oracle Data Pump Export if you want to use Oracle Data Pump Import with a PAR URL. See Oracle Data Pump Import with a Pre-Authenticated URL for details.