Re: SQLLoad / DIRECT Error

From: <abbeym_at_navcanada.ca>
Date: Wed, 22 Apr 1998 12:24:10 -0600
Message-ID: <6hl93q$qc0$1@nnrp1.dejanews.com>

In article <353DB3C8.7BD4196_at_NO-SPAM.aberdeen.geoquest.slb.com>#1/1,

> 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
>

I a DIRECT load aborts, any indexes on the affected tablesa re left in direct load state. They have to be dropped and recreated before they can be used again. When a DIRECT loads runs successfully to completion, the indexes on the affected objects are marked again as valid.

Michael

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed Apr 22 1998 - 13:24:10 CDT