DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: export

  1. #1
    Join Date
    Aug 2001
    Posts
    11
    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

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    query= \" where empno \> 1000 \" - this is UNIX specific string

    try:
    query= " where empno > 1000 "

  3. #3
    Join Date
    Sep 2001
    Location
    Fort Smith
    Posts
    184
    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

  4. #4
    Join Date
    Jan 2000
    Posts
    387
    Try this :
    exp file=d:\expdump.dmp log=d:\exp.log userid=scott/tiger tables=EMP query=\"where empno\>1000\"

  5. #5
    Join Date
    Sep 2001
    Posts
    9

    Talking syntax error

    Hi,
    Correct syntax is:
    exp userid=scott\tiger .......
    Note it should be backslash

  6. #6
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    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
  •  


Click Here to Expand Forum to Full Width