Home » SQL & PL/SQL » SQL & PL/SQL » Direct Path Loading
Direct Path Loading [message #263466] Thu, 30 August 2007 02:25 Go to next message
Messages: 6
Registered: November 2006
Location: Kochi
Junior Member

I tried the oracle utility SQLLDR.I created a table named
TEST1(id Number primary key,var varchar2(50).

I correcltly load data into TEST1 using normal load(not direct),bad file entries are filled with duplicate records

When direct path load is used,all data are loaded into TEST1 voilating PRIMARY KEY constraint.

After this i tried to insert data into TEST1 error showing table is in unusable state.

Again direct path loading is used it also shows same error as above

Please give me valuable information about the above problems

Regards Manojvilayil
Re: Direct Path Loading [message #263491 is a reply to message #263466] Thu, 30 August 2007 03:17 Go to previous message
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
That's how direct path works. The idea is not to violate the primary key.

To recover, you need to drop the index, delete the duplicates, then rebuild the index and enable the PK.

Ross Leishman
Previous Topic: Create User/Schema
Next Topic: list of characters
Goto Forum:

Current Time: Tue Oct 25 11:26:24 CDT 2016

Total time taken to generate the page: 0.13336 seconds