Home » Infrastructure » Unix » Export Parameter File Error.
Export Parameter File Error. [message #97414] Fri, 26 April 2002 06:15 Go to next message
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 Go to previous messageGo to next message
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 Go to previous message
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
Previous Topic: Problem installation Oracle 8.1.7 on RedHat 6.2
Next Topic: Re: Problem with Oracle installation on Linux
Goto Forum:
  


Current Time: Fri Mar 01 18:21:38 CST 2024