OracleLoader does not respect primary key

OracleLoader does not respect primary key

Postby 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
mgrant
 
Posts: 1
Joined: Wed 04 Feb 2009 21:50

Postby 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.
Shalex
Devart Team
 
Posts: 7608
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle