| Export Parameter File Error. [message #97414] |
Fri, 26 April 2002 06:15  |
Shashikanth Durgavajjhala
Messages: 2
Registered: April 2002
|
Junior Member |
|
|
Hi,
I am trying to export a TableData from a shell script. I have the following text in my export parameter file:
Export_start :: =
exp usr/pwd@connstring
ExpModes ExpOpts
ExpModes ::=
TABLES=EIW_PART_TABLES
ExpOpts ::=
ExpFileOpts
LOG=/dirpath/errlog.log
ROWS = Y
FEEDBACK = 1
INDEXES = Y
CONSTRAINTS = Y
ExpFileOpts ::=
PARFILE=/dirpath/myparamsfile/
FILE = /dirpath/TableDump.dmp
=========================================
In a shell script I am calling Export utility as below:
exp PARFILE="/dirpath/myparamsfile"
if [[ $? = 0 ]]
then
echo 'EXPORT COMPLETED SUCCESSFULLY'
else
echo 'EXPORT FAILED'
fi
=========================================
When I execute the above shell script, I get the below error:
LRM-00110: syntax error at 'exp'
LRM-00113: error when processing file '/dirpath/myparamsfile'
EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully
EXPORT FAILED
=========================================
Could someone help me with this please.
Thanks in advance.
Shashi.
|
|
|
|
| Re: Export Parameter File Error. [message #97415 is a reply to message #97414] |
Fri, 26 April 2002 09:02  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
You can't have spaces after any parameter.
good - ROWS=Y
not good - ROWS = Y
You should test your commands on one command line and not use a parameter file to make sure all your options work before you put them in a script.
|
|
|
|
| Re: Export Parameter File Error. [message #97424 is a reply to message #97414] |
Wed, 01 May 2002 06:22 |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
I ALWAYS use a flat parfile as follows (your parameters):
userid=usr/pwd@constring
TABLES=EIW_PART_TABLES
LOG=/dirpath/errlog.log
ROWS=Y
FEEDBACK=1
INDEXES=Y
CONSTRAINTS=Y
FILE=/dirpath/TableDump.dmp
Then do the export
%> exp parfile=parfile.par
Then I read the last line from the log file for the status of the export.
tail -1 /dirpath/errlog.log
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
