queryfile使用方法？

之前一直無法搞清楚exp/expdp中關(guān)于query參數(shù)的正確寫法，每次都是零散的印象，這次特意把這個(gè)記錄成日志以方便以后查看。關(guān)于query參數(shù)的寫法請(qǐng)參看以下兩個(gè)例子： 1.使用命令行： expdp t1/t1 directory=tl dumpfile=t2.dmp tables=t query="'where name=''a1'''" Export: Release 10.2.0.4.0 - 64bit Production on Thursday, 23 February, 2012 16:27:41 Copyright (c) 2003, 2007, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Starting "T1"."SYS_EXPORT_TABLE_01": t1/******** directory=tl dumpfile=t2.dmp tables=t query='where name=''a1''' Estimate in progress using BLOCKS method... Processing object type TABLE_Export/TABLE/TABLE_DATA Total estimation using BLOCKS method: 64 KB Processing object type TABLE_EXPORT/TABLE/TABLE . . exported "T1"."T" 5.234 KB 1 r... 之前一直無法搞清楚exp/expdp中關(guān)于query參數(shù)的正確寫法，每次都是零散的印象，這次特意把這個(gè)記錄成日志以方便以后查看。關(guān)于query參數(shù)的寫法請(qǐng)參看以下兩個(gè)例子： 1.使用命令行： expdp t1/t1 directory=tl dumpfile=t2.dmp tables=t query="'where name=''a1'''" Export: Release 10.2.0.4.0 - 64bit Production on Thursday, 23 February, 2012 16:27:41 Copyright (c) 2003, 2007, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Starting "T1"."SYS_EXPORT_TABLE_01": t1/******** directory=tl dumpfile=t2.dmp tables=t query='where name=''a1''' Estimate in progress using BLOCKS method... Processing object type TABLE_EXPORT/TABLE/TABLE_DATA Total estimation using BLOCKS method: 64 KB Processing object type TABLE_EXPORT/TABLE/TABLE . . exported "T1"."T" 5.234 KB 1 rows Master table "T1"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded ****************************************************************************** Dump file set for T1.SYS_EXPORT_TABLE_01 is: /home/oracle/tl/t2.dmp Job "T1"."SYS_EXPORT_TABLE_01" successfully completed at 16:27:46 2.使用參數(shù)文件： cat par.txt userid=t1/t1 file=t1.dmp log=tl.log tables=t query='where name=''a1''' [oracle@host101] ~/tl 1005>exp parfile=par.txt Export: Release 10.2.0.4.0 - Production on Thu Feb 23 16:44:13 2012 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set About to export specified tables via Conventional Path ... . . exporting table T 1 rows exported Export terminated successfully without warnings. 總結(jié)：如果在命令行中使用query，那么其中的條件需要用外層"加內(nèi)層'組成，如果條件中有字符串，則字符串中的'號(hào)變成''；如果是將query寫到參數(shù)文件中則只需要一層'即可，同樣字符串中的'轉(zhuǎn)換為''。