Using DBMS_DATAPUMP – Full Export and Filtering DB Tables (Metadata Filtering)
SELECT trim(instance_name), trim(host_name) INTO v_db_name, v_hostname FROM v$instance; v_dp_handle := DBMS_DATAPUMP.open( operation => ‘EXPORT’, job_mode => ‘FULL’, remote_link => NULL, …