There is a "query" option in Oracle exp utility, which enables you export filtered rows of a table by providing a where clause with this option. However this option is not widely used, many people do not clearly know how to specify a value for this option in Windows or UNIX platform, including me, and always get the following errors:
LRM-00112: multiple values not allowed for parameter 'query'
EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully
This is due the value always contains multiple words, we must to pack them together as one value to the exp utility by quoting the values. On Windows, we could specify this value as following:
exp ... query='where deptno=10'
exp ... query='where deptno=''10'''
exp ... query='where deptno "<" 10'
On UNIX platform, I tested the following command on Solaris, it works well.
exp ..... query=\"where col1 \< 1000\"
exp ..... query=\"where col1 \< '1000'\"
On other UNIX platform, it should work also. Now you should be able to use it freely. The simplest way is to prepare a parameter file for exp utility, then you do not need to quote the value at all.
Comments (2)
Came here from a Google search and am browsing from Safari. You may want to reconsider the ubiquitous CSS drop-shadow in your current design; the overall effect is blurry text, really nasty to read in browsers that support it.
Posted by jdb | September 21, 2007 1:34 AM
I did not test my site on Safari browser. It looks correct in IE and Firefox.
Posted by anysql | September 25, 2007 10:56 AM