Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQLLoad / DIRECT Error

SQLLoad / DIRECT Error

From: Alan Barclay <barclaya_at_NO-SPAM.aberdeen.geoquest.slb.com>
Date: Wed, 22 Apr 1998 10:09:29 +0100
Message-ID: <353DB3C8.7BD4196@NO-SPAM.aberdeen.geoquest.slb.com>


Hi,

I am setting up a system on Sun hardware with Oracle7.3.

I am loading lots of data files using SQLLoad (in Direct Mode) but often get the following error appearing, which then prevents any more loading into that table. What is going wrong? I think that my data files are OK as I use the same files elsewhereand also the table is straightforward and the same design is used elsewhere in the db.

Error parsing SQL statement for upi: [17] ORA-01502: index 'BLA.PK_TEST9999' is in direct load state

--
Alan Barclay
Schlumberger GeoQuest
barclaya_at_aberdeen.geoquest.slb.com Received on Wed Apr 22 1998 - 04:09:29 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US