DBMS_CLOUD - Spielwiese

  /* get infos from bucket store*/
  --https://docs.oracle.com/en/cloud/paas/autonomous-database/adbsa/dbms-cloud-subprograms.html
  BEGIN
     DBMS_CLOUD.CREATE_CREDENTIAL (
         credential_name => 'OCI_KEY_CRED',
         user_ocid       => 'ocid1.user.oc1..xx',
         tenancy_ocid    => 'ocid1.tenancy.oc1..xx',
         private_key     => 'KlEELVccx+gCs8Sw=',
         fingerprint     => '43:3f:0c:15:bd:cc:bf:48:5a:92:5b');
  END;
  /

  /* get infos from object */
  SELECT
      dbms_cloud.get_metadata(credential_name => 'OCI_KEY_CRED', 
      object_uri => 'https://objectstorage.eu-frankfurt-1.oraclecloud.com/p/xx/n/fryljaksyzkx/b/bucket_oia_mediafiles/o/xxxxxa.jpg-nhndnpdd')    
  FROM
      dual;

  /* write table into bucket store as json */    
  begin
    dbms_cloud.export_data (
      credential_name => 'OCI_KEY_CRED',
      file_uri_list   => 'https://objectstorage.eu-frankfurt-1.oraclecloud.com/p/xx/n/fryljaksyzkx/b/bucket_oia_mediafiles/o/costs.json',
      query           => 'select * from costs',
      format          => '{"type" : "JSON"}'
    );
  end;
  /
  /*dump file to bucket */
  BEGIN  
     DBMS_CLOUD.EXPORT_DATA(
        credential_name =>'OCI_KEY_CRED',
        file_uri_list =>'https://objectstorage.eu-frankfurt-1.oraclecloud.com/p/xx/n/fryljaksyzkx/b/bucket_oia_mediafiles/o/kia.dmp',
        format => json_object('type' value 'datapump', 'compression' value 'basic', 'version' value 'latest'),
        query => 'SELECT * FROM eniro'
       );
     END;
  /  

  BEGIN
  DBMS_CLOUD.BULK_DOWNLOAD (    
       credential_name => 'OCI_KEY_CRED',
       location_uri    => 'https://objectstorage.eu-frankfurt-1.oraclecloud.com/p/xx/n/fryljaksyzkx/b/bucket_oia_mediafiles/o',
       directory_name  => 'DATA_PUMP_DIR');
  end;
  /

  SELECT * FROM DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR');

  BEGIN
     DBMS_CLOUD.DELETE_FILE(
        directory_name =>  'DATA_PUMP_DIR',
        file_name => 'Dr.-xx_Wien.jpg' );
     END;
  / 

  /* write file into bucket store*/    
  declare
    l_file blob;
  begin
    l_file := utl_raw.cast_to_raw('This is another test file von tom');

    dbms_cloud.put_object (
      credential_name => 'OCI_KEY_CRED',
      object_uri      => 'https://objectstorage.eu-frankfurt-1.oraclecloud.com/p/xx/n/fryljaksyzkx/b/bucket_oia_mediafiles/o/test.txt',
      contents        => l_file);
  end;
  /