connect expid/expid

create table exptab(n number);

insert into exptab values(1);

insert into exptab values(9);

create table exptab1(n number);

insert into exptab1 values(1);

insert into exptab1 values(7);

create table exptab2(n number);

insert into exptab2 values(2);

insert into exptab2 values(8);

commit;

************
another db server

conn impid/impid


DECLARE
handle0 number;
Begin
handle0 := DBMS_DATAPUMP.open(
        operation => 'IMPORT',
        job_mode  => 'TABLE',
        remote_link => 'CONN_EXPID',
        job_name    => 'JOB31',
        version => 'LATEST'
        );


DBMS_DATAPUMP.METADATA_REMAP (
handle=>handle0,
name=>   'REMAP_SCHEMA',
old_value=>   'EXPID',
   value=>   'IMPID');


DBMS_DATAPUMP.METADATA_FILTER(
   handle=>handle0,
   name=>'NAME_EXPR',
   value=>'IN (''EXPTAB'',''EXPTAB1'')');

--not working
DBMS_DATAPUMP.METADATA_FILTER(
   handle=>handle0,
   name=>'SCHEMA_EXPR',
   value=>'IN (''EXPID'')');
/*
DBMS_DATAPUMP.DATA_FILTER(
   handle=>handle0,
   name=>'INCLUDE_ROWS',
   value=>1);
*/

[COLOR=red]DBMS_DATAPUMP.DATA_FILTER(
   handle=>handle0,
   name=>'SUBQUERY',
   value=>'WHERE N=1',
   table_name=>'EXPTAB'
   );[/COLOR]

--not working
DBMS_DATAPUMP.add_file(
    handle    => handle0,
    filename  => 'check31.log',
    directory => 'IMPDIR',
    filetype=>3);

DBMS_DATAPUMP.SET_PARAMETER(handle0,'TABLE_EXISTS_ACTION','SKIP');

    DBMS_DATAPUMP.start_job(handle0);
    DBMS_DATAPUMP.detach(handle0);

end;
/