How to use DBMS_DATAPUMP to write to a dba directory to your local client?
I would like to create a export dump file using DBMS_DATAPUMP to write to a directory on your local client. For example using the below script where LOCAL_DB_DIR is local to the client and not to the DB server.
------------------------------------------------------------------------------------------------------------------------
declare
h1 NUMBER;
begin
h1 := dbms_datapump.open(operation => 'EXPORT', job_mode => 'SCHEMA', job_name => 'SCHEMA_IMP_JOB');
dbms_datapump.add_file(handle => h1, filename => 'schema_x.dmp', directory => 'LOCAL_DB_DIR');
dbms_datapump.add_file(handle => h1, filename => 'schema_x.log', directory => 'LOCAL_DB_DIR', filetype => 3);
dbms_datapump.metadata_filter(handle => h1, name => 'SCHEMA_EXPR', value