export problem

From: harish <harishksh_at_yahoo.com>
Date: 12 Mar 2003 03:55:13 -0800
Message-ID: <ff46df6e.0303120355.280545e5@posting.google.com>

In the oracle 8i documentation the following is given for export utility

If user SCOTT wants to export only those employees whose job title is SALESMAN and whose salary is greater than 1600, he could do the following (note that this example is UNIX-based):

exp scott/tiger tables=emp query=\"where job=\'SALESMAN\' and sal\<1600\"

Note: 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 i tried to execute the above statement in my windows 2000 professional PC (oracle 8i) i got the following error

EXP 00056: Oracle error 911 encountered
ora 00911: Invalid character
export terminated successfully with warnings.

Since in documentation it is given that "Operating system reserved characters also need to be preceded by an escape character", what format we should follow in win 2000 pc for executing the above export statement. Received on Wed Mar 12 2003 - 05:55:13 CST