using your ADMIN account in Oracle Autonomous database environment you have two methods to export data using export datapump:

Oracle SQL Developer

DBMS_DATAPUMP API

Here I am going to simulate using DBMS_DATAPUMP API method:

First, I will create a user defined directory called “RAMBO” this directory will be appended automatically in the DBFS file system.

After that, I will use DBMS_DATAPUMP API to run export datapump job:

set scan off
set serveroutput on
set escape off
whenever sqlerror exit
DECLARE
h1 number;
s varchar2(1000):=NULL;
errorvarchar varchar2(100):= ‘ERROR’;
tryGetStatus number := 0;
success_with_info EXCEPTION;
PRAGMA EXCEPTION_INIT(success_with_info, -31627);
begin
h1 := dbms_datapump.open (operation => ‘EXPORT’, job_mode => ‘FULL’, job_name => ‘EXP_SD1’, version => ‘COMPATIBLE’);
tryGetStatus := 1;
dbms_datapump.set_parameter(handle => h1, name => ‘COMPRESSION’, value => ‘ALL’);
dbms_datapump.set_parallel(handle => h1, degree => 1);
dbms_datapump.add_file(handle => h1, filename => ‘EXPDAT-‘||to_char(sysdate,’hh24_mi_ss’)||’.LOG’, directory => ‘RAMBO’, filetype => 3);
dbms_datapump.set_parameter(handle => h1, name => ‘KEEP_MASTER’, value => 1);
dbms_datapump.add_file(handle => h1, filename => ‘EXPDAT%U-‘||to_char(sysdate,’hh24_mi_ss’)||’.DMP’, directory => ‘RAMBO’, filesize => ‘500M’, filetype => 1);
dbms_datapump.set_parameter(handle => h1, name => ‘INCLUDE_METADATA’, value => 1);
dbms_datapump.set_parameter(handle => h1, name => ‘DATA_ACCESS_METHOD’, value => ‘AUTOMATIC’);
dbms_datapump.set_parameter(handle => h1, name => ‘ESTIMATE’, value => ‘BLOCKS’);
dbms_datapump.start_job(handle => h1, skip_current => 0, abort_step => 0);
dbms_datapump.detach(handle => h1);
errorvarchar := ‘NO_ERROR’;
EXCEPTION
WHEN OTHERS THEN
BEGIN
IF ((errorvarchar = ‘ERROR’)AND(tryGetStatus=1)) THEN
DBMS_DATAPUMP.DETACH(h1);
END IF;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
RAISE;
END;
/

To list files (dump file and log file) generated:

SELECT * FROM DBMS_CLOUD.list_files(‘RAMBO’);