ORA-02292 integrity constraint violated

ragu · Post by **ragu** » Mon Nov 07, 2005 1:00 pm

Hello Everybody,

I have a parent table and a child table

I need to truncate and load these two tables
I have to process the parent table first
But this violates the integrity constraint because of the parent/ child relation

how do i implement delete cascade in this?

Suggest me any other method to implement this

Thank you

Regards,
Ragu

ray.wurlod · Post by **ray.wurlod** » Mon Nov 07, 2005 1:48 pm

You must comply with the rules. Change your load rule for the parent table so that rows are updated (rather than replaced), or allow automatic cascade on delete (ALTER TABLE), or drop/disable constraints before loading. Each of these is dangerous.

kcbland · Post by **kcbland** » Mon Nov 07, 2005 11:29 pm

How about totally create the parents and children first and write to flat files, using hash files as a means to stage your foreign keys.

Then, when ready to load, issue a command like call to sqlplus to execute a couple lines of TRUNCATE TABLE commands in the right order, then bulk load your rows. Sure would be much faster than OCI's since you're during TRUNC-N-LOAD.