Oracle Database Discussions

I'm experiment with Hybrid Table Partitions on 19c ATP Free Tier.

Right now, I'm stuck at trying to use an OCI Object Bucket for destination of exporting data for the external partition.

If I leave out the format line (see code), I can export only 1 column of data.

If I try to use “datapump”, I'm getting:

ORA-20000: unable to create dump file "https://objectstorage.us-ashburn-1.oraclecloud.com/n/ … /o/rn_exp_7.dmp". Please check the credential or if file already exists.

(User has read,write on DIRECTORY DATA_PUMP_DIR )

Any help will be appreciated.

thx

CODE

begin
  dbms_cloud.export_data(
    file_uri_list   => 'https://objectstorage.us-ashburn-1.oraclecloud.com/...../rn_exp_7.dmp',
    credential_name => 'OCI_BUCKET_CRED',
    format          => json_object( 'type' value 'datapump' ),
    query           => 'select * from random_numbers partition for (7)'
  );
end;
/