-
DBMS_Stats error message
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|