Database Utilities (MOSC)

MOSC Banner

Database Import (unique constraint violated)

edited Apr 10, 2012 7:02AM in Database Utilities (MOSC) 10 comments
I am attempting to perform an Oracle Schema Import from an Export dump.  I recieve the many of the below type errors. 

IMP-00019: row rejected due to ORACLE error 1
IMP-00003: ORACLE error 1 encountered
ORA-00001: unique constraint (V6OWNER.PK_ADDR) violated

Here are my import and export commands.  I am attempting to test the reorganization of two complete schemas.  I thought if I used the destroy parameter in the Export statement that it would overwrite the existing data.  I am looking to the export utility for easiest way to reorg all tables. 

Exp system/********@db02.kawneer.com owner=(v6owner,v6user) buffer=8192000 feedback=1000  file=f:\v6.dmp log=f:\exp_v6.log

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center