Database Tuning (MOSC)

MOSC Banner

RA-20001: Unable to drop table STAGE1: does not appear to be a statistics

edited May 17, 2018 1:45PM in Database Tuning (MOSC) 3 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center