Home » RDBMS Server » Server Utilities » ORA-00600
ORA-00600 [message #74231] Fri, 15 October 2004 01:03 Go to next message
Martin Marchant
Messages: 9
Registered: August 2004
Junior Member
I am trying to load some data using sqlload into a table but keep getting the error ORA-00600: internal error code, arguments: [[729]], [[511760]], [[space leak]], [[]], [[]], [[]], [[]], [[]]

It's only 497 rows of three fields so it's not a large amount of data. The log that the sqlload procedure produces also contains the error 'Index NT_USER_PK' was left in Direct Load State due to ORA-01536: space quota exceeded for tablespace 'NBS_IDX''

Any ideas would be much appreciated.

Ta, Martin 
Re: ORA-00600 [message #74234 is a reply to message #74231] Fri, 15 October 2004 03:16 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
WHat is the version of oracle and OS?
with HP-UX it is known issue. Increase the kernel parameters maxdsize and maxssize.
or
Try explicitly setting a low value for ROWS (sqlldr parameter).
Re: ORA-00600 [message #74235 is a reply to message #74234] Fri, 15 October 2004 03:52 Go to previous messageGo to next message
Martin Marchant
Messages: 9
Registered: August 2004
Junior Member
Version 7.3.2.2 running on an NCR box UNIX v4

Thanks, Martin
Re: ORA-00600 [message #74236 is a reply to message #74235] Fri, 15 October 2004 04:47 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Try explicitly setting a low value for ROWS (sqlldr parameter).
Re: ORA-00600 [message #74248 is a reply to message #74236] Wed, 20 October 2004 05:30 Go to previous message
Martin Marchant
Messages: 9
Registered: August 2004
Junior Member
That didn't work so I exported everything from that particular tablespace, recreated the tablespace, and reimported the structure. Reran the load scripts and everything worked fine. How weird is that?

Thanks for your assistance. Cheers!
Previous Topic: Data Migration
Next Topic: faq's in Logminer
Goto Forum:
  


Current Time: Mon Jul 01 07:59:52 CDT 2024