Cannot Target Object Storage Bucket As An ADW Data Pump Export Target With SQL Developer Wizard (Doc ID 2748539.1)

Last updated on APRIL 12, 2024

Applies to:

Symptoms

On : 20.4 version, DBA Functions (like User Mgmt)

Need to migrate a schema from one ADW (Oracle Autonomous Data Warehouse) instance to another ADW instance. Running SQL Developer from a Compute Instance, attempting to use the DBA/Data Pump Extract Wizard. Specifying the OSS prerequisite parameters (page 8 of 9 of the Export Wizard). The export .dmp file is successfully downloaded to the DATA_PUMP_DIR directory, but is not moved to the Object Storage Bucket.

Can perform export of schema and upload to Object Storage in OCI manually, but not able to perform using SQL Developer utility as it fails with the following message:
 

or


STEPS
-----------------------
Use the DBA's Data Pump Export Wizard to export a schema from an ADW instance, uploading it to an Object Storage bucket.
The export to DATA_PUMP_DIR completes, but the upload to Object Storage fails.
Repeat the process, exporting a different schema. But it also fails, which indicates it is not specific to one schema.
It can be any schema.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.