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