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
manojvilayil
Messages: 6
Registered: November 2006
Location: Kochi
Junior Member

Sir,
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
rleishman
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: Wed Dec 07 04:46:47 CST 2016

Total time taken to generate the page: 0.12366 seconds