Cannot Target Object Storage Bucket As An ADW Data Pump Export Target With SQL Developer Wizard
(Doc ID 2748539.1)
Last updated on FEBRUARY 01, 2021
Applies to:Oracle SQL Developer - Version 19.3 and later
Information in this document applies to any platform.
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:
Exception occurred during previous Data Pump Export wizard
Stage: Data Pump Export
Title: No files found
No files when expanding dump names
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document