Skip to Main Content
Forums

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

Timo Hahn

User, tell us your exact JDev version, please!
Your REST endpoint wouldn't make sense this way. The 'Employees' represent a collection that isn't parameterized by default. That's why you normally add something like 'action' or 'acton/test1' to the endpoint to make sure everybody knows that you do something on the collection of employees.
I would not encourage you to use the method at all, as in 12.2.1.4 you don't even get it in the wizard. It's easier to create your own REST service and call the application module methods from there. This way you can design your own API, e.g more like OpenAPI instead of relying on JDev and ADF.

Timo

Joby-Oracle

I am using Jdev 12.2.1.5.0.
I used the above link for reference.
My actual URL looks like:
{{hostAddress}}/restApp/resources/11.13.18.05/employees
I have added manually methodAction tag in the resource xml file , to enable the custom method.
So you are saying that this is not possible using ADF .

Timo Hahn
Answer

There is no official version 12.2.1.5. You are using an internal version not available to the public.
All I'm saying is that you don't even see the method tab in 12.2.1.4 and custom methods are depricated. So, yes, from my point of view you can't do it with ADF REST service.
It might be possible that you see the tab in your version, but then you have to ask this question to some internal resource.

Timo

Marked as Answer by Joby-Oracle · Jun 2 2022
1 - 3

Post Details

Added on Nov 3 2021
#developer, #sql-developer
3 comments
936 views