Re: SQLLoad / DIRECT Error

Hi,

there are some Bug's with this behavior, one is fixed in 8.0.2 the other in 7.3.3 the problem is the
alter table command.

If you are using bitmap indexes and they get in direct load state this Bug is fixed in 7.3.3.

Best Regards,

Ro

Alan Barclay wrote:

> 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 - 11:02:49 CDT