Failed to Export with Query parameter! [message #327639] |
Tue, 17 June 2008 02:13 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
mshravan_020
Messages: 4 Registered: June 2008
|
Junior Member |
|
|
Hello Group,
I have been working on Oracle Import/Export and this group helped me solve an issue in the past week. Thanks a lot.
Today, when am trying to "Export with Query parameter", I stumped in to an error as deatiled below:
$ exp training/training@testdb BUFFER=2000000 LOG=/home/oracle/msk_dumps/training_exp_cust01.log \
FILE=/home/oracle/msk_dumps/training_exp_cust01.dmp FILESIZE=536832000 RECORDLENGTH=64000 STATISTICS=NONE \
TABLES=CUSTOMERS QUERY="WHERE CUST_ID=17639"
LRM-00101: unknown parameter name 'CUST_ID'
EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully
I have double checked the CUSTOMERS table and it has the CUST_ID column defined and has lot of data in it.
I have goooogled around but could not find any useful information. Could any one help me solve this error and export data successfully with query parameter.
Thanks in advance,
Shravan
[Updated on: Tue, 17 June 2008 04:17] by Moderator Report message to a moderator
|
|
|
|
Re: Failed to Export with Query parameter! [message #327666 is a reply to message #327652] |
Tue, 17 June 2008 03:18 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
mshravan_020
Messages: 4 Registered: June 2008
|
Junior Member |
|
|
Actually, in the code block the exp command is lengthier and I thought it should not be broken in to multiple lines, to give a realistic explanation of my problem.
I have removed my rating for my topic. I thought my rating for this topic should help others answer/go through the topic.
Could you please provide solution to my issue.
|
|
|
Re: Failed to Export with Query parameter! [message #327686 is a reply to message #327666] |
Tue, 17 June 2008 04:19 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote: | Actually, in the code block the exp command is lengthier and I thought it should not be broken in to multiple lines, to give a realistic explanation of my problem.
|
You could use \ at the end of the line to show the split.
Quote: | I have removed my rating for my topic.
|
Actually I did it.
Quote: | Could you please provide solution to my issue
|
Backslash the " of your query part.
Regards
Michel
|
|
|