Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data Pump Export to Object Storage via SQL Developer

JakeNov 3 2021

Hi,
I am trying to run data pump in Autonomous Database via SQL Developer Data Pump Export Wizard. Target is to send the dump to the Object Storage. We won't have access to the server so SQL Developer is the only option.
Data pump is completing but unable to copy to OSS and I get below exception:

######################
Exception occurred during previous Data Pump Export wizard

Stage: Data Pump Export
Title: No files found
MessageText:
No files when expanding dump names
#####################

Am I using the correct parameters here??
Target URL (Bucket): https://objectstorage.us-ashburn-1.oraclecloud.com/n/xxxxxx/b/oci-bucket001/o/
Oracle Directory path Override: https://objectstorage.us-ashburn-1.oraclecloud.com/n/xxxxxx/b/oci-bucket001/o/test_export%U.dmp

Comments

Zoltan Kecskemethy

Have you measured network connection speed between two systems?

Mannamal-Oracle

Copy to Hadoop, a feature licensed with Oracle Big Data SQL, is a better alternative to Sqoop.  Faster and supported by Oracle.

1 - 2

Post Details

Added on Nov 3 2021
3 comments
860 views