DIRECT option in SQL*Loader

I have some problem with SQL*Loader.

I tried to use it with the option

        DIRECT=TRUE to insert a number of rows into the table with primary key. It worked one time but after that the unique index defined on the primary key column was put into status DIRECT LOAD and remained in that status preventing further transactions on that table (including further sqlload runs).

I run Oracle 7.0.12.1.0. This is the diagnostics I received from SQL*Loader:

SQL*Loader: Release 7.0.12.1.0 - Production on Fri Mar 29 11:34:44 1996

Copyright (c) Oracle Corporation 1979, 1992. All rights reserved.

Error calling once/load initialization
ORA-01502: index 'PROFAX.T1_PK' is in direct load state

I would greatly appreciate if someone can share how to properly use DIRECT option of SQL*Loader.

Mikhail Semenov

msemenov_at_cyberdata.com Received on Thu Mar 28 1996 - 00:00:00 CET