Lin Hong's TECH Blog! 刀不磨要生锈,人不学习要落后 - Thinking ahead

Oracle ADB export data to Other Database Tips

2022-12-20

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


Similar Posts

Comments