Shulou(Shulou.com)06/01 Report--

When conducting data in actual production, you may need to import part of the data to the test library, and the query parameters of expdp can meet this requirement.

Database version

Zx@ORCL > select * from v$version

BANNER

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0-64bit Production

PL/SQL Release 11.2.0.4.0-Production

CORE11.2.0.4.0Production

TNS for Linux: Version 11.2.0.4.0-Production

NLSRTL Version 11.2.0.4.0-Production

Create a test table

Zx@ORCL > create table E1 (id number,name varchar2 (20))

Table created.

Zx@ORCL > create table e2 (id number,birthday date)

Table created.

Insert test data

Zx@ORCL > insert into E1 select level,lpad (level,20,'*') from dual connect by level commit

Commit complete.

Zx@ORCL > insert into e2 select level,sysdate-50+level from dual connect by level commit

Commit complete.

Create a directory

Zx@ORCL > create directory dir as'/ home/oracle/'

Directory created.

Zx@ORCL > host

Test using query export

[oracle@rhel6 ~] $expdp zx/zx directory=dir dumpfile=e1.dmp tables=zx.e1 query=zx.e1:\ "where idselect dbms_flashback.get_system_change_number from dual

GET_SYSTEM_CHANGE_NUMBER

-

2179047

Zx@ORCL > select count (*) from E1

COUNT (*)

-

one hundred

Delete part of the data

Zx@ORCL > delete from E1 where idcommit

Commit complete.

Zx@ORCL > host

Test query and flashback_scn

[oracle@rhel6 ~] $expdp zx/zx directory=dir dumpfile=e1_1.dmp tables=zx.e1 query=zx.e1:\ "where id\"

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.