ORA-13223 duplicate entry in SDO_GEOM_METADATA index during import
(Doc ID 837218.1)
Last updated on OCTOBER 11, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.4 [Release 10.2]Information in this document applies to any platform.
This problem can occur on any platform.
Symptoms
Import gives following errors:
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type TABLE_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX
ORA-39083: Object type INDEX failed to create with error:
ORA-13223: duplicate entry for <table name.column name> in SDO_GEOM_METADATA
ORA-06512: at "MDSYS.MD", line 1723
ORA-06512: at "MDSYS.MDERR", line 17
ORA-06512: at "MDSYS.<trigger name>", line 48
ORA-04088: error during execution of trigger 'MDSYS.<trigger name>'
Failing sql is:
BEGIN
declare schema_name varchar2(200); username varchar2(64); begin execute immediate 'select sys_context(''userenv'', ''CURRENT_SCHEMA'') from dual ' into sch...
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |