SET SERVEROUTPUT ON; DECLARE v_dp_handle NUMBER; BEGIN v_dp_handle := DBMS_DATAPUMP.open( operation => 'EXPORT', mode => 'SCHEMA', remote_link => dblink_destination, job_name => Null, version => 'COMPATIBLE ); DBMS_DATAPUMP.set_parallel( handle => v_dp_handle, degree => 1 ); DBMS_DATAPUMP.add_file( handle => v_dp_handle, filename => 'EXPORT_DBUSER_110001_01.dmp', directory => 'DATA_PUMP_DIR' --, filetype => 3 ); DBMS_DATAPUMP.add_file( handle => v_dp_handle, filename => 'EXPORT_DBUSER_110001_02.dmp', directory => 'DATA_PUMP_DIR' ); DBMS_DATAPUMP.add_file( handle => v_dp_handle, filename => 'EXPORT_DBUSER_110001_03.dmp', directory => 'DATA_PUMP_DIR' ); DBMS_DATAPUMP.add_file( handle => v_dp_handle, filename => 'EXPORT_DBUSER_110001_04.dmp', directory => 'DATA_PUMP_DIR' ); DBMS_DATAPUMP.start_job( handle => v_dp_handle, skip_current => 0, abort_step => 0 ); WHEN OTHERS THEN raise_application_error(-20001,'An error was encountered - '|| SQLCODE||' -ERROR- '||SQLERRM); END; /
23424