Hi All,

When I am trying to execute the STATS GATHER on one particular Table its giving the following error message :

ORA-20011: Approximate NDV failed: ORA-08103: object no longer exists
ORA-06512: at "SYS.DBMS_STATS", line 24281
ORA-06512: at "SYS.DBMS_STATS", line 24332

Code to do stats gather :

DBMS_STATS.GATHER_TABLE_STATS (ownname=>'SCHEMA_NAME', TABNAME=> 'TABLE_NAME' , CASCADE=>TRUE,   degree=>16); 

There is possibility to run this statement two times exactly at the same time.Only few times we are getting this error messages.
Most of the cases its working fine .

Please help me to resolve the issue.What are circumstances which to leads to this error.

Thanks
Revathi.T

Thanks EdStevens for your interest to resolve the issue.

You are right.There is one more job which was execution at the same time for the same procedure with different parameter.

That table is list partitioned on branch column which contains different location .

Same procedure will be triggered at the same time with the two different branches.

Thanks
Revathi.T