This content has been marked as final. Show 2 replies
There are duplicate values in the target table that the import accessed to create the unique index. Anyway, i don't understand what you are trying to achieve? Are you trying to import the export to the same schema?
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found Cause: A CREATE UNIQUE INDEX statement specified one or more columns that currently contain duplicate values. All values in the indexed columns must be unique by row to create a UNIQUE INDEX. Action: If the entries need not be unique, remove the keyword UNIQUE from the CREATE INDEX statement, then re-execute the statement. If the entries must be unique, as in a primary key, then remove duplicate values before creating the UNIQUE index.
I think you already have some schemas tables data ,you can truncate tables and
impdp admin/XXXXs DIRECTORY=DATA_PUMP_DIR dumpfile=XXXX_24_08_2010.DMP LOGFILE=XXX_24_08_2010.LOG schemas=XXXXX
add TABLE_EXISTS_ACTION parameter
impdp admin/XXXXs DIRECTORY=DATA_PUMP_DIR dumpfile=XXXX_24_08_2010.DMP LOGFILE=XXX_24_08_2010.LOG schemas=XXXXX TABLE_EXISTS_ACTION=append or TABLE_EXISTS_ACTION=truncate or TABLE_EXISTS_ACTION= REPLACE