Database Administration - You have taken import of a table in a database. you have got the Integrity constraint violation erro

GeekInterview.com > Interview Questions > Oracle > Database Administration

Go To First | Previous Question | Next Question

Database Administration | Question 104 of 231

You have taken import of a table in a database. you have got the Integrity constraint violation error. How you are going to resolve it.

Total Answers and Comments: 4

Last Update: September 24, 2007 Asked by: Gaurav

Sponsored Links

Best Rated Answer

—

Submitted by: balakrishna

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

Above answer was rated as good by the following members:
patrick_francis

May 17, 2006 04:01:21

SRINIVAS

RE: You have taken import of a table in a database. yo...

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.

Is this answer useful? Yes | No

May 18, 2006 16:56:51

Mirik

RE: You have taken import of a table in a database. yo...

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

Is this answer useful? Yes | No

May 28, 2006 03:24:47

balakrishna

RE: You have taken import of a table in a database. yo...

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

Is this answer useful? Yes | No

1 0

Overall Rating: +1

September 24, 2007 12:37:07

senthilora

Member Since: October 2006 Contribution: 7

RE: You have taken import of a table in a database. yo...

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

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank