Fawzia
At first glance, it appears that the error has something to do with the
first lines of the file. Is there any possibility that you created/edited
this file on a different system than you are running it on? It looks as if
you have several blank lines at the top of the file. I would remove
Fawzia,
Try the following (change parfile= to control=)
sqlldr control=pants.ctl log=me.log
parfile is for imp/exp.
Good Luck!
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, September 02, 2003 1:20 PM
To: Multiple recipients of list ORACLE-L
You are specifying pants.ctl as parfile, not control, as you should.
Replace parfile= with control= in your command line.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, September 02, 2003 8:19 PM
PLEASE Can someone help??I
Congratulations Thomas!
You win the eagle-eye prize of the day! Unfortunately it is a virtual prize.
Funny what an obscure error sqlldr produced.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, September 02, 2003 1:05 PM
To:
John,
I didn't say that a parameter file can't be used. The correct syntax is
control=, not parfile=.
And I agree about postings. I posted that message yesterday at around noon.
FInally showed up today. But my email server is flaky.
Tom Mercadante
Oracle Certified Professional
PLEASE Can someone help??I have a sqlloader control file below and I am
getting the following error when I run it and I just cant see what is
wrong!!!
Rgds
Fawzia
[EMAIL PROTECTED] sqlldr parfile=pants.ctl log=me.log
LRM-00110: syntax error at 'LOAD'
LRM-00113: error when processing file
Syntax looks right.
Does the operating system user have read privs on the csv file?
Does the database user running this have insert privs on the table?
If those are ok, then try retyping the first couple lines of the ctl
file as there may be a hidden control character messing things up.
Good
List,
I am currently working on migrating an application from Oracle 7.3 to Oracle
8.1.6.2 (This is on Solaris 2.6). One of the shell scripts makes use of
sqlload ($ORACLE_HOME/bin/sqlload) which exists on the 7.3 server but not on
the 8.1.6.2 server. On the 7.3 server it looks like
Ken,
Earlier versions had sqlldr and sqlload as copies of the same code. I
think sqlload was a link in 8.0.x. Now with 8i it's gone. You can create the
link if you do not wish to change the existing code. We did just that since
Developers did not want to change their scripts.
HTH,
Regards