Home » RDBMS Server » Server Utilities » SQl loader
SQl loader [message #431991] Fri, 20 November 2009 05:29 Go to next message
karthickbab
Messages: 16
Registered: November 2009
Location: India
Junior Member
The following error occured in Sql loader. Can any one solve this?

F:\>sqlldr userid='sys/sys' control='f:\load_con.ctl' log='f:\load_log.log';
LRM-00112: multiple values not allowed for parameter 'log'

SQL*Loader: Release 9.2.0.1.0 - Production on Thu Nov 19 16:59:26 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL*Loader-100: Syntax error on command-line
Re: SQl loader [message #431992 is a reply to message #431991] Fri, 20 November 2009 05:35 Go to previous messageGo to next message
ThomasG
Messages: 3184
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
1) Is there a log file specified in the control file, too?

2) You don't need a semicolon at the end of a command line. Maybe that's causing some confusion.
Re: SQl loader [message #431993 is a reply to message #431992] Fri, 20 November 2009 05:38 Go to previous messageGo to next message
karthickbab
Messages: 16
Registered: November 2009
Location: India
Junior Member
After removing semi colon the following error occurs.

F:\>sqlldr userid='sys/sys' control='f:\load_con.ctl' log='f:\load_log.log'

SQL*Loader: Release 9.2.0.1.0 - Production on Thu Nov 19 17:11:30 2009

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

SQL*Loader-128: unable to begin a session
ORA-01017: invalid username/password; logon denied
Re: SQl loader [message #432002 is a reply to message #431993] Fri, 20 November 2009 05:56 Go to previous messageGo to next message
ThomasG
Messages: 3184
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You have an invalid user name and password.

And you should use "sys" *ONLY* for database administration purposes anyway, never for loading data or some such.

Use a normal database user for that.



Re: SQl loader [message #432024 is a reply to message #431993] Fri, 20 November 2009 08:05 Go to previous message
joy_division
Messages: 4615
Registered: February 2005
Location: East Coast USA
Senior Member
And get rid of the single quotes. They add nothing and can only hurt.
Previous Topic: Mulitple tables data loading
Next Topic: EXP/IMP 8.0.5
Goto Forum:
  


Current Time: Sun Sep 25 04:16:09 CDT 2016

Total time taken to generate the page: 0.05248 seconds