RA-20001: Unable to drop table STAGE1: does not appear to be a statistics
Hi,
11.2 database, I'm trying to drop a statistics table
SQL> exec DBMS_STATS.DROP_STAT_TABLE ('SYSADM','stage1');
BEGIN DBMS_STATS.DROP_STAT_TABLE ('SYSADM','stage1'); END;
*
ERROR at line 1:
ORA-20001: Unable to drop table STAGE1: does not appear to be a statistics table
ORA-06512: at "SYS.DBMS_STATS", line 12457
ORA-06512: at line 1
I'm positive stage1 is a statistic table that I created using DBMS_STATS.CREATE_STAT_TABLE. Case is not the problem. I tried uppercase and lowercase table name, I got same error message.
Have anyone had this problem? And how did you solve it?
thanks