topic IMP-00017: following statement failed with ORACLE error 4020: in Data Management Questions https://community.esri.com/t5/data-management-questions/imp-00017-following-statement-failed-with-oracle/m-p/639411#M36173 <HTML><HEAD></HEAD><BODY><SPAN>Why I get this error while importing arcsde for oracle 10gr2?</SPAN><BR /><SPAN>I have windows server 2003sp2, oracle 10.2.0.4 version</SPAN><BR /><BR /><SPAN>IMP-00017: following statement failed with ORACLE error 4020:</SPAN><BR /><SPAN> "ASSOCIATE STATISTICS WITH TYPES "ST_GEOMETRY" USING "ST_DOMAIN_STATS""</SPAN><BR /><SPAN>IMP-00003: ORACLE error 4020 encountered</SPAN><BR /><SPAN>ORA-04020: deadlock detected while trying to lock object 30x6CAFD9D00x6ABAF6180x6DF00520</SPAN><BR /><SPAN>IMP-00017: following statement failed with ORACLE error 4020:</SPAN><BR /><SPAN> "ASSOCIATE STATISTICS WITH PACKAGES "ST_RELATION_OPERATORS" USING "ST_DOMAIN"</SPAN><BR /><SPAN> "_STATS""</SPAN><BR /><SPAN>IMP-00003: ORACLE error 4020 encountered</SPAN><BR /><SPAN>ORA-04020: deadlock detected while trying to lock object 30x6CAFD9D00x6ABAF6180x6DF00520</SPAN><BR /><SPAN>IMP-00017: following statement failed with ORACLE error 4020:</SPAN><BR /><SPAN> "ASSOCIATE STATISTICS WITH PACKAGES "ST_DOMAIN_OPERATORS" USING "ST_DOMAIN_S"</SPAN><BR /><SPAN> "TATS""</SPAN><BR /><SPAN>IMP-00003: ORACLE error 4020 encountered</SPAN><BR /><SPAN>ORA-04020: deadlock detected while trying to lock object 30x6C780E340x6ABAF6180x6DF00520</SPAN><BR /><SPAN>IMP-00017: following statement failed with ORACLE error 4020:</SPAN><BR /><SPAN> "ASSOCIATE STATISTICS WITH INDEXTYPES "ST_SPATIAL_INDEX" USING "ST_DOMAIN_ST"</SPAN></BODY></HTML> Fri, 08 Jul 2011 04:54:23 GMT ahmadawada 2011-07-08T04:54:23Z IMP-00017: following statement failed with ORACLE error 4020: https://community.esri.com/t5/data-management-questions/imp-00017-following-statement-failed-with-oracle/m-p/639411#M36173 <HTML><HEAD></HEAD><BODY><SPAN>Why I get this error while importing arcsde for oracle 10gr2?</SPAN><BR /><SPAN>I have windows server 2003sp2, oracle 10.2.0.4 version</SPAN><BR /><BR /><SPAN>IMP-00017: following statement failed with ORACLE error 4020:</SPAN><BR /><SPAN> "ASSOCIATE STATISTICS WITH TYPES "ST_GEOMETRY" USING "ST_DOMAIN_STATS""</SPAN><BR /><SPAN>IMP-00003: ORACLE error 4020 encountered</SPAN><BR /><SPAN>ORA-04020: deadlock detected while trying to lock object 30x6CAFD9D00x6ABAF6180x6DF00520</SPAN><BR /><SPAN>IMP-00017: following statement failed with ORACLE error 4020:</SPAN><BR /><SPAN> "ASSOCIATE STATISTICS WITH PACKAGES "ST_RELATION_OPERATORS" USING "ST_DOMAIN"</SPAN><BR /><SPAN> "_STATS""</SPAN><BR /><SPAN>IMP-00003: ORACLE error 4020 encountered</SPAN><BR /><SPAN>ORA-04020: deadlock detected while trying to lock object 30x6CAFD9D00x6ABAF6180x6DF00520</SPAN><BR /><SPAN>IMP-00017: following statement failed with ORACLE error 4020:</SPAN><BR /><SPAN> "ASSOCIATE STATISTICS WITH PACKAGES "ST_DOMAIN_OPERATORS" USING "ST_DOMAIN_S"</SPAN><BR /><SPAN> "TATS""</SPAN><BR /><SPAN>IMP-00003: ORACLE error 4020 encountered</SPAN><BR /><SPAN>ORA-04020: deadlock detected while trying to lock object 30x6C780E340x6ABAF6180x6DF00520</SPAN><BR /><SPAN>IMP-00017: following statement failed with ORACLE error 4020:</SPAN><BR /><SPAN> "ASSOCIATE STATISTICS WITH INDEXTYPES "ST_SPATIAL_INDEX" USING "ST_DOMAIN_ST"</SPAN></BODY></HTML> Fri, 08 Jul 2011 04:54:23 GMT https://community.esri.com/t5/data-management-questions/imp-00017-following-statement-failed-with-oracle/m-p/639411#M36173 ahmadawada 2011-07-08T04:54:23Z