Home » RDBMS Server » Backup & Recovery » Failed to Export with Query parameter! (Oracle 9i/ 10.2.0.1.0, Solaris/Linux)
icon9.gif  Failed to Export with Query parameter! [message #327639] Tue, 17 June 2008 02:13 Go to next message
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 #327652 is a reply to message #327639] Tue, 17 June 2008 02:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For your information, I decide to no more answer to those who rates their own question before there is any answer.

In addition, keep your lines in 80 characters.

Regards
Michel
Re: Failed to Export with Query parameter! [message #327666 is a reply to message #327652] Tue, 17 June 2008 03:18 Go to previous messageGo to next message
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
Michel Cadot
Messages: 64103
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

Previous Topic: rman
Next Topic: bakup
Goto Forum:
  


Current Time: Sun Dec 04 00:34:12 CST 2016

Total time taken to generate the page: 0.07259 seconds