在exp中使用QUERY选项的范例

 昨天用了exp里面的QUERY选项，记录了一下。

名称等信息，已经做了修改。

 

1. 取范围。

[xxx]# exp user/pass@TNS_NAME FILE=/tmp/test_a.dmp TABLES=table_a QUERY=/"WHERE id# /<6/"

Export: Release 10.2.0.1.0 - Production on Thu Nov 6 01:02:16 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table           TABLE_A          5 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.
[xxx]#

 

2. 取相等（数值类型）。

[xxx]# exp user/pass@TNS_NAME FILE=/tmp/test_b.dmp TABLES=table_a QUERY=/"WHERE id#=3/"

Export: Release 10.2.0.1.0 - Production on Thu Nov 6 01:04:13 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table           TABLE_A          1 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.
[xxx]#

 

3. 取相等（字符类型）。

[xxx]# exp user/pass@TNS_NAME FILE=/tmp/test_c.dmp TABLES=table_a QUERY=/"WHERE COL_DESC=/'TEST_C/'/"

Export: Release 10.2.0.1.0 - Production on Thu Nov 6 01:06:48 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table               TABLE_A          1 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
Export terminated successfully with warnings.
[xxx]#