Hi All,

Recently I realized that when I run the DBMS_Stat in new schema , gives me error message, but is working fine in some other schema which I have.
here is the spool of SQLplus:


SQL> exec dbms_stats.gather_schema_stats(ownname=>'HR');

PL/SQL procedure successfully completed.
SQL> exec dbms_stats.gather_schema_stats(ownname=>'TEST-12');
BEGIN dbms_stats.gather_schema_stats(ownname=>'TEST-12'); END;

*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.DBMS_ASSERT", line 163
ORA-06512: at "SYS.DBMS_STATS", line 926
ORA-06512: at "SYS.DBMS_STATS", line 947
ORA-06512: at "SYS.DBMS_STATS", line 1005
ORA-06512: at "SYS.DBMS_STATS", line 11236
ORA-06512: at "SYS.DBMS_STATS", line 11214
ORA-06512: at line 1


SQL>


If some one can help it would be appreciated.

regards,
Keb