From: sbobba@us.imshealth.com (bobbas)
Newsgroups: comp.databases.oracle.server
Subject: Ora-600 error while using SQL*Loader in Oracle 9i database
Date: 12 Dec 2001 09:38:19 -0800
Organization: http://groups.google.com/
Lines: 10
Message-ID: <94f502ed.0112120938.43c18398@posting.google.com>
NNTP-Posting-Host: 162.44.245.32
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1008178700 30794 127.0.0.1 (12 Dec 2001 17:38:20 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 12 Dec 2001 17:38:20 GMT


I am trying to use Sql*loader in direct mode on Oracle 9i database and
I am getting ORA-600 errors. I used the same datafiles and same
control files a month ago and never had this problem. But now I get
this error and the error is not consistent. Some days it happen
consistently and some times it works fine. I tried using conventional
load and most of the times I don't get ORA-600 erros, but sometimes I
do. Once I make few changes by trucating table or by dropping indexes,
it works fine. Any clues on what's going on and what needs to be done.
Any help is gretely appreciated. I ran dbverify and none of the
datafiles are corrupted.