CREATE OR REPLACE DIRECTORY MIGDMP3 AS '\\myfileserver\dmpBackupFolder';
GRANT READ, WRITE ON DIRECTORY MIGDMP3 TO C##BBE_FRESH13;
GRANT export full database TO C##BBE_FRESH13;
DECLARE
h1 number;
s varchar2(1000);
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 => 'SCHEMA', job_name => 'Mig2_BBE_13v5', version => 'COMPATIBLE');
        tryGetStatus := 1;
        dbms_datapump.set_parallel(handle => h1, degree => 1);
        dbms_datapump.add_file(handle => h1, filename => 'BBE_FRESH13v5_EXPDAT.LOG', directory => 'MIGDMP3', filetype => 3);
        dbms_datapump.set_parameter(handle => h1, name => 'KEEP_MASTER', value => 1);
        dbms_datapump.metadata_filter(handle => h1, name => 'SCHEMA_EXPR', value => 'IN(''C##BBE_FRESH13'')');
        dbms_datapump.add_file(handle => h1, filename => 'BBE_FRESH13v5_EXPDAT%U.DMP', directory => 'MIGDMP3', filesize => '100M', 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;

Directory MIGDMP3 created.


Grant succeeded.


Grant succeeded.


Error starting at line : 4 in command -
DECLARE
h1 number;
s varchar2(1000);
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 => 'SCHEMA', job_name => 'Mig2_BBE_13v5', version => 'COMPATIBLE');
        tryGetStatus := 1;
        dbms_datapump.set_parallel(handle => h1, degree => 1);
        dbms_datapump.add_file(handle => h1, filename => 'BBE_FRESH13v5_EXPDAT.LOG', directory => 'MIGDMP3', filetype => 3);
        dbms_datapump.set_parameter(handle => h1, name => 'KEEP_MASTER', value => 1);
        dbms_datapump.metadata_filter(handle => h1, name => 'SCHEMA_EXPR', value => 'IN(''C##BBE_FRESH13'')');
        dbms_datapump.add_file(handle => h1, filename => 'BBE_FRESH13v5_EXPDAT%U.DMP', directory => 'MIGDMP3', filesize => '100M', 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;
Error report -
ORA-39002: invalid operation
ORA-06512: at line 32
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4932
ORA-06512: at "SYS.DBMS_DATAPUMP", line 5183
ORA-06512: at line 12
39002. 00000 -  "invalid operation"
*Cause:    The current API cannot be executed because of inconsistencies
           between the API and the current definition of the job.
           Subsequent messages supplied by DBMS_DATAPUMP.GET_STATUS
           will further describe the error.
*Action:   Modify the API call to be consistent with the current job or
           redefine the job in a manner that will support the specified API.