How is it possible that database - table export dump has duplicate records that have unique indexed columns in my source table?
In detail:
My source table - tab1 has 100 records wherein cola+colb are unique indexed columns. So it doesn't have any duplicates there.
But when i Export the tab1 and view at the exported dump i could find that some 10 records are duplicated.
So when i import the dump into another schema , the data gets loaded into that second schema. but on creating the unique index I get error message "SQL Error: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found 01452. 00000 - "cannot CREATE UNIQUE INDEX; duplicate keys found"
Since the duplicates are available in my source dump causing this issue.
I dont know why the duplicates are in my exported data when my source tables doesnt have any duplicates.
Please help on this?
Thanks