Thursday, March 15, 2012

SDE schema import and Oracle error ora-30512

I was importing sde schema from an export taken before a failed sde 10 upgrading. And the following error occurred:


. . importing table                     "VERSIONS"          1 rows imported
IMP-00017: following statement failed with ORACLE error 4020:
 "ASSOCIATE STATISTICS WITH PACKAGES "ST_RELATION_OPERATORS" USING "ST_DOMAIN"
 "_STATS""
IMP-00003: ORACLE error 4020 encountered
ORA-04020: deadlock detected while trying to lock object 30x3A00344700x39ECF02680x3A436F958
IMP-00017: following statement failed with ORACLE error 4020:
 "ASSOCIATE STATISTICS WITH INDEXTYPES "ST_SPATIAL_INDEX" USING "ST_DOMAIN_ST"
 "ATS""
IMP-00003: ORACLE error 4020 encountered
ORA-04020: deadlock detected while trying to lock object 30x3A00344700x39ECF02680x3A436F958
IMP-00017: following statement failed with ORACLE error 4020:
 "ASSOCIATE STATISTICS WITH TYPES "ST_GEOMETRY" USING "ST_DOMAIN_STATS""
IMP-00003: ORACLE error 4020 encountered
ORA-04020: deadlock detected while trying to lock object 30x3A0C6A1300x39ECF02680x3A436F958
About to enable constraints...
IMP-00017: following statement failed with ORACLE error 30512:
 "ALTER TABLE "ST_GEOMETRY_COLUMNS" ENABLE CONSTRAINT "GEOM_SRID_FK1""
IMP-00003: ORACLE error 30512 encountered
ORA-30512: cannot modify SDE.ST_GEOMETRY_COLUMNS more than once in a transaction
Import terminated successfully with warnings.

I googled "ora 30512" and got the following link:

And for sure the error can be ignored: It is safe to ignore the Oracle IMP utility error ORA-30512. Even though the error is encountered and reported in the Oracle import log, the GEOM_SRID_FK1 constraint is successfully enabled.

Next time it is better to use IMPDP/EXPDP instead of IMP/EXP.



More Oracle DBA tips, please visit Oracle DBA Tips 

No comments:

Post a Comment