Re: DIRECT option in SQL*Loader

From: Gene Gurevich <geneg_at_umich.edu>
Date: 1996/04/05
Message-ID: <Pine.SOL.3.91.960405152326.11373A-100000_at_qix.rs.itd.umich.edu>#1/1


> Mikhail Semenov <misha> wrote:
> >I have some problem with SQL*Loader.
 Error calling once/load initialization
> >ORA-01502: index 'PROFAX.T1_PK' is in direct load state
> >Mikhail Semenov
> >msemenov_at_cyberdata.com

Usually if an index is left in the DIRECT LOAD state, something was wrong during the exesution of the SQL*Loader script. Look at the .log file for an error message.
The only way I know to fix the problem you referred to is to drop the index that is left in the DIRECT LOAD state. Received on Fri Apr 05 1996 - 00:00:00 CEST

Original text of this message