Stage the Data Pump Export in Object Storage

Follow the steps below to import the Data Pump file, export.dmp, to Oracle Cloud Infrastructure Object Storage where Oracle Autonomus Database will be able to access it. This additional step is required as Oracle Database Cloud Schema Service does not support data export directly to Object Storage.

Note:

Oracle recommends that you upload large Data Pump export files using Oracle Cloud Infrastructure CLI rather than the Object Storage console. To learn more, see Using Multipart Uploads in Oracle Cloud Infrastructure Documentation.

1. Sign in to Oracle Cloud Infrastructure.
2. Expand the top left menu and, in the Core Infrastructure section, expand the Object Storage sub-menu and click Object Storage.
3. Pick an existing compartment and the existing bucket or create a new bucket.
4. Click on the bucket name and then click Upload Objects.
5. Choose the Data Pump export file, export.dmp, and click Upload Objects.
   
   
   Description of the illustration upload_objects.png
   
   
6. After the upload completes, open the context menu for the uploaded export.dmp. Click View Object Details, and copy the URL Path (URI) value. You will provide this value to the impdp utility later.

For additional information, see:

• Using the Console to upload and download objects in Managing Objects in Oracle Cloud Infrastructure Documentation