SQL> conn scott/oracle
Connected.
SQL> set serveroutput on
declare
hand number;
ind number;
job_state varchar(20);
le ku$_LogEntry;
sts ku$_Status;
begin
hand:= Dbms_DataPump.Open(operation => 'EXPORT',
job_mode => 'TABLE',
job_name => 'SCOTT_TBL_EXPJOB3');
Dbms_DataPump.MetaData_Filter(handle => hand,
name => 'NAME_EXPR',
value => 'like (''DE%'')');
Dbms_DataPump.Data_Filter(handle => hand,
name => 'SUBQUERY',
-- value => 'where dname = ''SALES''',
value => 'where deptno = 10',
table_name => 'DEPT');
Dbms_DataPump.Add_File(handle => hand,
filename => 'SCOTT_table_expdp.log',
directory => 'DUMP_FILE_DIR',
filetype => 3);
Dbms_DataPump.Add_File(handle => hand,
filename => 'SCOTT_table_expdp.dmp',
directory => 'DUMP_FILE_DIR',
filetype => 1);
Dbms_DataPump.Start_job(hand);
end;
[oracle@linux5 dmp]$ ls
123.dmp dept_exp_20_2.log dept_exp_20.log scott.log SCOTT_table_expdp.log
dept_10.dmp dept_exp_20.dmp scott.dmp SCOTT_table_expdp.dmp