Discussions
Categories
- 196.7K All Categories
- 2.2K Data
- 235 Big Data Appliance
- 1.9K Data Science
- 449.8K Databases
- 221.5K General Database Discussions
- 3.8K Java and JavaScript in the Database
- 31 Multilingual Engine
- 549 MySQL Community Space
- 477 NoSQL Database
- 7.9K Oracle Database Express Edition (XE)
- 3K ORDS, SODA & JSON in the Database
- 532 SQLcl
- 4K SQL Developer Data Modeler
- 186.8K SQL & PL/SQL
- 21.3K SQL Developer
- 295.4K Development
- 17 Developer Projects
- 138 Programming Languages
- 292.1K Development Tools
- 104 DevOps
- 3.1K QA/Testing
- 645.9K Java
- 28 Java Learning Subscription
- 37K Database Connectivity
- 153 Java Community Process
- 105 Java 25
- 22.1K Java APIs
- 138.1K Java Development Tools
- 165.3K Java EE (Java Enterprise Edition)
- 17 Java Essentials
- 158 Java 8 Questions
- 85.9K Java Programming
- 79 Java Puzzle Ball
- 65.1K New To Java
- 1.7K Training / Learning / Certification
- 13.8K Java HotSpot Virtual Machine
- 94.2K Java SE
- 13.8K Java Security
- 203 Java User Groups
- 24 JavaScript - Nashorn
- Programs
- 394 LiveLabs
- 37 Workshops
- 10.2K Software
- 6.7K Berkeley DB Family
- 3.5K JHeadstart
- 5.6K Other Languages
- 2.3K Chinese
- 170 Deutsche Oracle Community
- 1.1K Español
- 1.9K Japanese
- 230 Portuguese
Data Pump Export to Object Storage via SQL Developer
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
Answers
-
We won't have access to the server so SQL Developer is the only option
Copying the DMP file(s) to the Object Store with SQLDev will only work if SQLDev is on the server with the database (and has access to those DMP files).
We know that's not ideal, so we're adding Data Pump support to SQLcl and it will be able to stream the DMPs files down from the server (from anywhere) and then load them up to the Object Store. That's coming later this year.
-
Copying the DMP file(s) to the Object Store with SQLDev will only work if SQLDev is on the server with the database (and has access to those DMP files). -- How should that be set up in Autonomous DB?
Currently, I am accessing ADW through the SQL Developer in my RDP. And since I don't have access to the Linux server, we cannot issue expdp commands, so we are trying to use SQL Dev to run the export.
The goal is to do table refresh to our lower-env, but ADB only offer full database clone.
Thanks,
-Jake
-
We built the feature you're using to help get their data INTO Autonomous/Object store...you're already there, so it's much easier.
You can do everything via HTTPS if you want. You can kick off the export job via:
+ REST API or
+ SQLDev Wizard or
+ PL/SQL calls in worksheet...
...and then download the DMP file and logs from SQL Developer Web. Or use DBMS_CLOUD to PUT the file to Object Store
