EXP 数据库数据 QUERY 选项使用问题 |
| |
本文地址:http://www.apub.org/doc/2006/03/11/09/14/43/5968.html | |
原文出处:http://www.itpub.net/221227.html |
============================================
For example, if user scott wants to export only those employees whose job title is salesman and whose salary is less than 1600, he could do the following (this example is UNIX-based):
Because the value of the QUERY parameter contains blanks, most operating systems require that the entire strings WHERE job='salesman' and sal<1600 be placed in double quotation marks or marked as a literal by some method. Operating system reserved characters also need to be preceded by an escape character. See your operating system-specific documentation for information about special and reserved characters on your system.
When executing this query, Export builds a SQL SELECT statement similar to the following:
例子(WINNT上执行通过):
exp system/system QUERY="WHERE b_id>=1 and b_id<1000" buffer=8192 tables=usr1.buget_t feedback=50 consistent=n compress=n filesize=2G log=buget_log file=(buget_1, buget_2)
QUERY
Default: none
This parameter allows you to select a subset of rows from a set of tables when doing a table mode export. The value of the query parameter is a string that contains a WHERE clause for a SQL SELECT statement that will be applied to all tables (or table partitions) listed in the TABLE parameter.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-84372/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-84372/