Regarding query option in export utility???

[rksudhakar]

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

[shailendra]

TRY THIS

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

Hope this will work
Shailendra

[rksudhakar]

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

[SANJAY_G]

Can you post the error message?

Sanjay

[rksudhakar]

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

[shailendra]

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

[SANJAY_G]

You are missing a double quote.
Have a look at this.

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

Sanjay

[rksudhakar]

Got it. Thanks for the help.

Rgds,
Sudhakar