Script for gathering statistics gave error in one index - the other indexes where analyzed
I don't know why the following script gave error: all the other indexes in the script where analyzed except this one.
--creates on the fly index analyze script for existing indexes for $M_USER
@/export/home/oracle/dba/scripts/ANALYZE/idx_ercadmin_analyze.sql
EXECUTE DBMS_STATS.GATHER_INDEX_STATS(OWNNAME=> '&1', INDNAME=> 'PK_TBL_ORDER',
PARTNAME=> NULL)
BEGIN DBMS_STATS.GATHER_INDEX_STATS(OWNNAME=> 'ERCADMIN', INDNAME=> 'PK_TBL_ORDE
R', PARTNAME=> NULL); END;
*
ERROR at line 1:
ORA-00904: : invalid identifier
ORA-06512: at "SYS.DBMS_STATS", line 7807
ORA-06512: at line 1
--creates on the fly index analyze script for existing indexes for $M_USER
@/export/home/oracle/dba/scripts/ANALYZE/idx_ercadmin_analyze.sql
EXECUTE DBMS_STATS.GATHER_INDEX_STATS(OWNNAME=> '&1', INDNAME=> 'PK_TBL_ORDER',
PARTNAME=> NULL)
BEGIN DBMS_STATS.GATHER_INDEX_STATS(OWNNAME=> 'ERCADMIN', INDNAME=> 'PK_TBL_ORDE
R', PARTNAME=> NULL); END;
*
ERROR at line 1:
ORA-00904: : invalid identifier
ORA-06512: at "SYS.DBMS_STATS", line 7807
ORA-06512: at line 1
0