Assumptions

• You have a list of table names to export.

• You have a read/write prefix-level PAR URI for an Oracle Object Storage bucket.

• You want to export each table as JSON – CSV has issues with null in the last column.

• Each table’s data will be stored under a URI path like <PAR_URI>/table_name.

• You will use DBMS_CLOUD.EXPORT_DATA for export and DBMS_CLOUD.COPY_DATA for import.

• Multi-part and timestamped files will be generated during export.

• You are importing into existing tables with matching structures in the destination ADW.