ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found or silent corruption / rounding of the fractional seconds part of timestamp with timezone data during expdp/impdp (Doc ID 1608635.1)

Last updated on DECEMBER 05, 2016

Applies to:

Oracle Database - Standard Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 13-Sep-2016***

Symptoms

 
during impdp these errors are seen

ORA-39083: Object type INDEX failed to create with error:
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

on a timestamp with timezone column

OR


silent corruption / rounding of the fractional seconds part of timestamp with timezone data is seen

for example a timestamp with timezone column has these rows

12/09/2012 16:45:22.897000 Europe/Brussels
12/09/2012 16:45:25.097000 Europe/Brussels
12/09/2012 16:45:27.406000 Europe/Brussels

but after the import using impdpd the following values are shown in table:

12-SEP-12 16.45.23.000000 Europe/Brussels
12-SEP-12 16.45.25.000000 Europe/Brussels
12-SEP-12 16.45.27.000000 Europe/Brussels

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms