Oracle ADB export data to Other Database Tips
Export data to csv via sql
The simplest guide to exporting data from Autonomous Database directly to Object Storage
Other data moving option
Moving Data from Autonomous Database to Other Oracle Databases
Steps:
1. Copy the object using put_object
2. Confirm with list_objects in OSS
Using Oracle Autonomous Database on Shared Exadata Infrastructure
PUT_OBJECT Procedure
This procedure is overloaded. In one form the procedure copies a file from Autonomous Database to the Cloud Object Storage. In another form the procedure copies a BLOB from Autonomous Database to the Cloud Object Storage.
Example:
BEGIN
DBMS_CLOUD.PUT_OBJECT(
credential_name => 'OBJ_STORE_CRED',
object_uri => 'https://xxxxxxxxxxxxxxxxxxxxx/ADB_ExpData.dmp',
directory_name => 'DATA_PUMP_DIR',
file_name => 'ADB_ExpData.dmp');
END;
/
- list objects in OSS
select object_name, bytes from dbms_cloud.list_objects('OBJ_STORE_CRED','https://xxxxxxx/Bucket/') where object_name like '%ADB_ExpData%';
- list objects in ATP datapump dir
SELECT * FROM table(dbms_cloud.list_files('DATA_PUMP_DIR')) WHERE object_name LIKE '%ADB_ExpData%';
Reference
Refer:
The simplest guide to exporting data from Autonomous Database directly to Object Storage
Other data moving option
Moving Data from Autonomous Database to Other Oracle Databases
Using Oracle Autonomous Database on Shared Exadata Infrastructure
Have a good work&life! 2022/12 via LinHong