Printable View
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
TRY THIS
exp userid=wms/ace123win0@wms file=c:\test.dmp tables=product_location query=\'where customer_code = 'RE001'\"
Hope this will work
Shailendra
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
Can you post the error message?
Sanjay
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
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
You are missing a double quote.
Have a look at this.
http://www.samoratech.com/OraUtil/swEXPQUERY.htm
Sanjay
Got it. Thanks for the help.
Rgds,
Sudhakar