OraFAQ Forum: Server Utilities » SQL Loader: finished with process status 2

Home » RDBMS Server » Server Utilities » SQL Loader: finished with process status 2 (9i)

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

SQL Loader: finished with process status 2 [message #351810]

Fri, 03 October 2008 05:17

smashingmc
Messages: 4
Registered: October 2008

Junior Member

Hi,
i have problem with SQL loader.
02.10.08_17:28:20 : SQL loader process started
02.10.08_17:28:21 : SQL loader process finished with process status 2
02.10.08_17:28:21 : SQLLDR Error : SQL loader process finished with process status 2 for file

Anybody have some ideas what should be wrong? It was works for few years before without problems so i don't understand it at all.

thanks a lot

Milan

Report message to a moderator

Re: SQL Loader: finished with process status 2 [message #351816 is a reply to message #351810]

Fri, 03 October 2008 05:52

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Check SQL*Loader log.

Regards
Michel

Report message to a moderator

Re: SQL Loader: finished with process status 2 [message #351818 is a reply to message #351810]

Fri, 03 October 2008 05:55

Michel Cadot
Messages: 68648
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Have a look at
Oracle9i Database Utilities
Chapter 4 SQL*Loader Command-Line Reference
Section Exit Codes for Inspection and Display

Regards
Michel

Report message to a moderator

Re: SQL Loader: finished with process status 2 [message #351824 is a reply to message #351816]

Fri, 03 October 2008 06:41

smashingmc
Messages: 4
Registered: October 2008

Junior Member

Hi Michel,
where i should find that SQL*Loader log? our admin can't find anything like that Sad

Sad

thanks for your advance

milan

Report message to a moderator

Re: SQL Loader: finished with process status 2 [message #351832 is a reply to message #351818]

Fri, 03 October 2008 07:08

smashingmc
Messages: 4
Registered: October 2008

Junior Member

so we found the problem.
In file we used as delimeter “,” but our SQL*Loader waits “.”

thanks for you help one more time

Milan

Report message to a moderator

Previous Topic:	QUERY TO DETERMINE THE SIZE OF TABLE
Next Topic:	IMPDP with constraints

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 07 19:06:20 CDT 2024