| SQl loader [message #431991] |
Fri, 20 November 2009 05:29  |
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  |
ThomasG
Messages: 3212
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 |
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 |
ThomasG
Messages: 3212
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.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
