-
Hi,
I am trying to export based on condition . I am getting following errors.
exp scott/tiger file=emp.dmp log=emp.log tables=emp query= \" where empno \> 1000 \"
EXP-00056: ORACLE error 911 encountered
ORA-00911: invalid character
Export terminated successfully with warnings.
Operating system I am using is Windows/2000. Please help me in writing correct statement.
Thanks in advance.
joedba
-
query= \" where empno \> 1000 \" - this is UNIX specific string
try:
query= " where empno > 1000 "
-
THIS IS THE CORRECT SYNTAX
exp scott/tiger tables=emp file=d:\expdump.dmp log=d:\exp.log query=\"where empno>1000\"
sonofsita
http://www.ordba.net
-
Try this :
exp file=d:\expdump.dmp log=d:\exp.log userid=scott/tiger tables=EMP query=\"where empno\>1000\"
-
syntax error
Hi,
Correct syntax is:
exp userid=scott\tiger .......
Note it should be backslash
-
Hi YoungDBA,
The error is not in the userid, it's in the query.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|