 Failed to Export with Query parameter! [message #327639] |
Tue, 17 June 2008 02:13  |
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  |
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 |
 |
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
