Hi ,
When i collecting statistic at table level i am getting the below error,
please help why it is coming and how it is get resolved.
SQL> EXECUTE DBMS_STATS.GATHER_TABLE_STATS ('RAMESH','DC11');
BEGIN DBMS_STATS.GATHER_TABLE_STATS ('RAMESH','DC11'); END;
*
ERROR at line 1:
ORA-01187: cannot read from file because it failed verification tests
ORA-06512: at "SYS.DBMS_STATS", line 40751
ORA-06512: at "SYS.DBMS_STATS", line 40035
ORA-06512: at "SYS.DBMS_STATS", line 38912
ORA-06512: at "SYS.DBMS_STATS", line 37089
ORA-06512: at "SYS.DBMS_STATS", line 34971
ORA-06512: at "SYS.DBMS_STATS", line 34606
ORA-06512: at "SYS.DBMS_STATS", line 34138
ORA-06512: at "SYS.DBMS_STATS", line 33778
ORA-01110: data file 202: '/u01/app/oracle/oradata/test/temp012.dbf'
ORA-06512: at "SYS.DBMS_LOB", line 741
ORA-06512: at "SYS.DBMS_STATS", line 33743
ORA-06512: at "SYS.DBMS_STATS", line 34055
ORA-06512: at "SYS.DBMS_STATS", line 34518
ORA-06512: at "SYS.DBMS_STATS", line 34518
ORA-06512: at "SYS.DBMS_STATS", line 34957
ORA-06512: at "SYS.DBMS_STATS", line 36653
ORA-06512: at "SYS.DBMS_STATS", line 38738
ORA-06512: at "SYS.DBMS_STATS", line 39738
ORA-06512: at "SYS.DBMS_STATS", line 40183
ORA-06512: at "SYS.DBMS_STATS", line 40732
ORA-06512: at line 1
there are the temporary tablespace details
TS# STATUS ENABLED NAME
---------- ------- ---------- -----------------------------------------------------
3 ONLINE READ WRITE /u01/app/oracle/oradata/test/temp01.dbf
3 ONLINE READ WRITE /u01/app/oracle/oradata/test/temp012.dbf