-
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
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
|