OraFAQ Forum: Server Utilities » Where is Error Log for SQL Loader on Windows XP?

Home » RDBMS Server » Server Utilities » Where is Error Log for SQL Loader on Windows XP?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Where is Error Log for SQL Loader on Windows XP? [message #145071]

Mon, 31 October 2005 14:10

ozzy318
Messages: 4
Registered: October 2005
Location: New York

Junior Member

I am runing SQL Loader using the sqlldr command with a control file to load data into a table. The data is not getting loaded, and I can not find a log file that will tell what the problem is. Can anyone tell me where to find this log?

Report message to a moderator

Re: Where is Error Log for SQL Loader on Windows XP? [message #145074 is a reply to message #145071]

Mon, 31 October 2005 14:16

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

In the same directory / folder from which you invoked the sqlldr.

Report message to a moderator

Re: Where is Error Log for SQL Loader on Windows XP? [message #145080 is a reply to message #145074]

Mon, 31 October 2005 15:38

ozzy318
Messages: 4
Registered: October 2005
Location: New York

Junior Member

Thanks Mahesh,
I invoked it from the "run" window. I looked in the directory that the executable resides and I could not find it. Do you know what the name of the file is so I can search the directories for it?

Report message to a moderator

Re: Where is Error Log for SQL Loader on Windows XP? [message #145085 is a reply to message #145080]

Mon, 31 October 2005 17:55

Barbara Boehmer
Messages: 9100
Registered: November 2002
Location: California, USA

Senior Member

If you did not specify a name for the log file, then there isn't one. If you are not sure of your default paths, then specify complete paths, as in the follwing example:

d:\oracle\ora92\bin\sqlldr.exe scott/tiger control=c:\oracle\your_control_file.ctl log=c:\temp\your_log_file.log

If you are still having problems, then post a copy and paste of the exact command that you are using, your control file, your table structure, and a sample of your data file.

Report message to a moderator

Re: Where is Error Log for SQL Loader on Windows XP? [message #145088 is a reply to message #145071]

Mon, 31 October 2005 18:55

ozzy80
Messages: 55
Registered: June 2005

Member

If u have invoked sqlldr by clicking on the 'run' and typing cmd.. then u should be able to find the path there... else by default it should be c:/documents and settings/<user>....

I have lil knowledge on it... just trying to help as much as I can... anybody plz correct me if I am wrong...

Report message to a moderator

Re: Where is Error Log for SQL Loader on Windows XP? [message #145345 is a reply to message #145085]

Wed, 02 November 2005 10:40

ozzy318
Messages: 4
Registered: October 2005
Location: New York

Junior Member

I have decided to run this from a Command Prompt window so as to see the results on the screen. This is what I have gotten:

---------------------------------------------------------------
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Azriel>sqlldr SYSTEM/PASSWORD control = "C:\Documents and Settings\Azriel\My Documents\Computer\Scripts\load_trades_tmp.ctl", log="c:\
oracle\product\10.2.0\LOGS\sqlldr_110205.log"
LRM-00112: multiple values not allowed for parameter 'control'

SQL*Loader: Release 10.2.0.1.0 - Production on Wed Nov 2 11:37:18 2005

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL*Loader-100: Syntax error on command-line
----------------------------------------------------------------

Why does it think I am sending multile control files?

Report message to a moderator

Re: Where is Error Log for SQL Loader on Windows XP? [message #145699 is a reply to message #145345]

Fri, 04 November 2005 23:10

Barbara Boehmer
Messages: 9100
Registered: November 2002
Location: California, USA

Senior Member

You have a comma between your control file specification and your log file specification that does not belong there. Also, you have spaces on both sides of one of the equal signs that are not allowed. Please see the corrected command line below.

C:\Documents and Settings\Azriel>sqlldr SYSTEM/PASSWORD control="C:\Documents and Settings\Azriel\My Documents\Computer\Scripts\load_trades_tmp.ctl" log="c:\
oracle\product\10.2.0\LOGS\sqlldr_110205.log"

Report message to a moderator

Re: Where is Error Log for SQL Loader on Windows XP? [message #145803 is a reply to message #145699]

Sun, 06 November 2005 21:30

ozzy318
Messages: 4
Registered: October 2005
Location: New York

Junior Member

I ran it again reoving commas and blank spaces. This is what I got:

----------------------------------------------------------------
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Azriel>sqlldr SYSTEM/PASSWORD control="C:\Documents and Settings\Azriel\My Documents\Computer\Scripts\load_trades_tmp.ctl" log="c:\oracle\product\10.2.0\LOGS\sqlldr_110205.log"
LRM-00112: multiple values not allowed for parameter 'control'

SQL*Loader: Release 10.2.0.1.0 - Production on Sun Nov 6 22:24:41 2005

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL*Loader-100: Syntax error on command-line
---------------------------------------------------------------

Help

Report message to a moderator

Previous Topic:	resultset
Next Topic:	Running SQL*Loader from Windows NT batch file

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 09 00:56:02 CST 2024