| DBMS_STATS ORA-06502 [message #74023] |
Thu, 26 August 2004 08:03 |
P Lacroix
Messages: 1
Registered: August 2004
|
Junior Member |
|
|
when I first use
begin
dbms_stats.gather_schema_stats
(ownname => USER,
options => 'GATHER EMPTY',
cascade => true);
end;
/
I get the following error:
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_STATS", line 4602
ORA-06512: at "SYS.DBMS_STATS", line 4725
ORA-06512: at "SYS.DBMS_STATS", line 4697
ORA-06512: at line 2
The schema has no stats on any table or indexes.
but if I use the same block again it completes succesfully without doing anything in between.
I verified the dba_tables and dba_indexes views and the stats have been gathered.
What is happenning?
Is the package failing when there are many tables to do?
Please explain?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
