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

Thread: Regarding query option in export utility???

  1. #1
    Join Date
    Jun 2002
    Posts
    16
    Hi All,

    I tried to use the query option available in the exp utility it works fine with numbers and dates but I am not able to use charater columns i try to use the following but getting error

    exp userid=wms/ace123win0@wms file=c:\test.dmp tables=product_location query='where customer_code = 'RE001''

    Rgds,
    Sudhakar

  2. #2
    Join Date
    Sep 2000
    Posts
    305
    TRY THIS

    exp userid=wms/ace123win0@wms file=c:\test.dmp tables=product_location query=\'where customer_code = 'RE001'\"

    Hope this will work
    Shailendra


  3. #3
    Join Date
    Jun 2002
    Posts
    16
    I try to use the command given but still getting error , i try using different combinations still unable to, those who have used this feature can post an example for the same.

    Rgds,
    Sudhakar

  4. #4
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Can you post the error message?

    Sanjay

  5. #5
    Join Date
    Jun 2002
    Posts
    16
    The error message is as follows:-

    LRM-00111: no closing quote for value ''
    EXP-00019: failed to process parameters, type ' EXP HELP= Y' for help
    EXP-00000: Export terminated unsuccessfully

    Rgds,
    Sudhakar

  6. #6
    Join Date
    Sep 2000
    Posts
    305
    check out your query parameter carfefully

    I am again pasting the query parameter for you please copy this parameter and paste it and run it.

    query= \"where customer_code = 'RE001'\"

    Shailendra




  7. #7
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    You are missing a double quote.
    Have a look at this.

    http://www.samoratech.com/OraUtil/swEXPQUERY.htm

    Sanjay

  8. #8
    Join Date
    Jun 2002
    Posts
    16
    Got it. Thanks for the help.

    Rgds,
    Sudhakar

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