SQL> declare
2 l_handle number;
3 begin
4 -- Open a table export job.
5 l_handle := dbms_datapump.open(
6 operation => 'EXPORT',
7 job_mode => 'TABLE',
8 remote_link => NULL,
9 version => 'LATEST');
10
11 -- Specify the dump file name and directory object name.
12 dbms_datapump.add_file(
13 handle => l_handle,
14 filename => 'par.dmp',
15 directory => 'CTMP');
16
17 -- Specify the log file name and directory object name.
18 dbms_datapump.add_file(
19 handle => l_handle,
20 filename => 'par.log',
21 directory => 'CTMP',
22 filetype => DBMS_DATAPUMP.KU$_FILE_TYPE_LOG_FILE);
23
24 -- Specify the table to be exported, filtering the schema and table.
25 dbms_datapump.metadata_filter(
26 handle => l_handle,
27 name => 'SCHEMA_EXPR',
28 value => '= ''SCOTT''');
29
30 dbms_datapump.metadata_filter(
31 handle => l_handle,
32 name => 'NAME_EXPR',
33 value => '= ''T''');
34
35 DBMS_DATAPUMP.DATA_FILTER(
36 handle => l_handle,
37 name => 'SUBQUERY',
38 value => 'WHERE ( object_id < 200000 AND owner = ''SYS'' )
39 OR ( object_id >= 800000 AND object_id < 1000000 AND owner = ''SCOTT'' )',
40 table_name => 'T');
41
42
43 dbms_datapump.start_job(l_handle);
44
45 dbms_datapump.detach(l_handle);
46 end;
47 /
PL/SQL procedure successfully completed.
SQL>
SQL>