GSS Errorred out

Posted by Satish on Feb 26, 2020; 6:58am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/GSS-Errorred-out-tp8092.html

Dear Erman,
 
Gather schema statistics is errored out daily with below errors:
 
In GATHER_SCHEMA_STATS , schema_name= ALL percent=  degree = 4 internal_flag= NOBACKUP
Error #1: ERROR: While GATHER_TABLE_STATS:
object_name=XXAHC.XXAHC.XXAHC_GL_FIN_PERIOD***ORA-20001: XXAHC.XXAHC_GL_FIN_PERIOD is an invalid identifier***
Error #2: ERROR: While GATHER_TABLE_STATS:
object_name=XXAHC.XXAHC_gl_int_check_tbl***ORA-20000: Unable to analyze TABLE "XXAHC"."XXAHC_GL_INT_CHECK_TBL", insufficient privileges or does not exist***
Error #3: ERROR: While GATHER_TABLE_STATS:
object_name=XXAHC.XXAHC_gl_int_chk_tbl1***ORA-20000: Unable to analyze TABLE "XXAHC"."XXAHC_GL_INT_CHK_TBL1", insufficient privileges or does not exist*
 
 
SQL> select OWNER,OBJECT_NAME from dba_objects where OBJECT_NAME='XXAHC_GL_INT_CHECK_TBL';
 
OWNER       OBJECT_NAME
APPS        XXAHC_GL_INT_CHECK_TBL
 
SQL>  select OWNER,OBJECT_NAME from dba_objects where OBJECT_NAME='XXAHC_GL_INT_CHECK_TBL1';
 
no rows selected

XXAHC_GL_INT_CHECK_TBL1 is not existing to drop but log is showing this table

SQL> select OWNER,TABLE_NAME,LAST_ANALYZED,STATTYPE_LOCKED from DBA_TAB_STATISTICS where STATTYPE_LOCKED like 'ALL'
and owner like 'APPS';  
no rows selected

SQL>select OWNER,TABLE_NAME,LAST_ANALYZED,STATTYPE_LOCKED from DBA_TAB_STATISTICS where STATTYPE_LOCKED like 'ALL'
and owner like 'XXAHC';  
no rows selected

 
We dropped the table XXAHC_GL_INT_CHECK_TBL and ran GSS late night and again faced the same issue...We could see the table exist again.Can you please suggest some way to fix this?


Thank you