Re: DIRECT option in SQL*Loader

From: Bob Manieri <bmanieri_at_ford.com>
Date: 1996/04/01
Message-ID: <4jp45f$fkg_at_eccdb1.pms.ford.com>#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

Mikhail:
Try dropping the indexes before you load. This will get you better performance after you're done loading. If the index is a primary key constraint drop and recreate after it after the load as a unique index, just makes life easier.
Hope this helps!
Bob.

---

Bob Manieri                           email : bmanieri_at_ford.com
Database Administrator                voice : (610) 584-7085
Ford Electronics, Lansdale, PA        pager : (609) 342-0314
------------------------------------------------------------------

Business is war....information is the high ground. - J.Abrahamson ..we can deprive the enemy of the high ground. - J. Buford

---

Received on Mon Apr 01 1996 - 00:00:00 CEST