SRINIVAS

• May 17th, 2006

 

use this DDL statement in create table script to avoid integrity constraint violation error DROP TABLE tabl_name CASCADE CONSTRAINTS ;

cascade constraints delete foreign keys associated with table and table frees with foreign keys.

Mirik

• May 18th, 2006

 

You should import with option constraints=no and after that investigating which rows force the constraint

balakrishna

• May 28th, 2006

 

if u want to import the table just say constraints=n the movement table got imported then u create constriant on that tables.

senthilora

 Profile Answers by senthilora 

• Sep 24th, 2007

 

Another suggestion could be: Find the Master Table(s) of the given table and export / import them all.