Wednesday, May 8, 2013

New Gather Schema Statistics errors

After moving to Exadata we were able to change some of our operational tasks, and one of those was to run our Gather Schema Statistics with the ALL parameter instead of chunking it out by our biggest schema names because of how fast it runs.  With that, comes finding errors we never saw before and one of which was "ORA-20001: invalid column name or duplicate columns/column groups/expressions in method_opt" for these items:

Schema       Object
--------       -------
FIIFII_FIN_ITEM_HIERARCHIES
APJE_CH_PAYMENT_REF
JE_FR_DAS_010
JE_FR_DAS_010_NEW
JG_ZZ_SYS_FORMATS_ALL_B
JG_ZZ_SYS_FORMATS_ALL_TL
GLJE_BE_LINE_TYPE_MAP
JE_BE_LOGS
JE_BE_VAT_REP_RULES
ALLJE_BE_LINE_TYPE_MAP
JE_BE_LOGS
JE_BE_VAT_REP_RULES

Searching My Oracle Support I was able to find a direct hit with note "Gather Schema Statistics fails with Ora-20001 errors after 11G database upgrade [ID 781813.1]" that was able to walk me through the way to identify which items were an issue, and how they could be resolved.

No comments:

Post a Comment