Home » RDBMS Server » Server Utilities » SQL Loader: finished with process status 2 (9i)
SQL Loader: finished with process status 2 [message #351810] Fri, 03 October 2008 05:17 Go to next message
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
Re: SQL Loader: finished with process status 2 [message #351816 is a reply to message #351810] Fri, 03 October 2008 05:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Check SQL*Loader log.

Regards
Michel
Re: SQL Loader: finished with process status 2 [message #351818 is a reply to message #351810] Fri, 03 October 2008 05:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
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
Re: SQL Loader: finished with process status 2 [message #351824 is a reply to message #351816] Fri, 03 October 2008 06:41 Go to previous messageGo to next message
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

thanks for your advance

milan
Re: SQL Loader: finished with process status 2 [message #351832 is a reply to message #351818] Fri, 03 October 2008 07:08 Go to previous message
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
Previous Topic: QUERY TO DETERMINE THE SIZE OF TABLE
Next Topic: IMPDP with constraints
Goto Forum:
  


Current Time: Mon Nov 04 06:31:02 CST 2024