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
OracleLoader does not respect primary key
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.
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.