OracleLoader does not respect primary key

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
mgrant
Posts: 1
Joined: Wed 04 Feb 2009 21:50

OracleLoader does not respect primary key

Post by mgrant » Wed 04 Feb 2009 22:00

I have a table:
CREATE TABLE "COST_CENTER"
( "COST_CENTER" VARCHAR2(4 BYTE) NOT NULL ENABLE,
"NAME" VARCHAR2(35 BYTE),
"PHONE" VARCHAR2(10 BYTE),
PRIMARY KEY ("COST_CENTER")

That I load using OracleLoader and it works great. However, when I load the same file a second time, i expected to get a key violation error. But no error at all occured. It loaded the entire file a second time. Since the primary key has duplicates, the index becomes invalid. What do I need to do to prevent duplicate records?

Thanks,
Mike

Shalex
Site Admin
Posts: 8248
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 05 Feb 2009 13:19

The OracleLoader uses direct path load interface to speed up loading. The direct path load interface has some limitations. Particularly, referential integrity constraints are not supported.
For more information, please refer to http://download.oracle.com/docs/cd/B283 ... i13obn.htm , the Limitations and Restrictions of the Direct Path Load Interface section.

Post Reply