dbms_stats.gather_schema_stats [message #197156] |
Tue, 10 October 2006 05:15 |
M.Shakeel Azeem
Messages: 226 Registered: September 2006
|
Senior Member |
|
|
In 8i Server Environment
SQL> /
exec dbms_stats.gather_schema_stats(ownname => 'CLARK',cascade => true, options => 'GATHER EMPTY');
*
ERROR at line 1:
ORA-00900: invalid SQL statement
When i check the alert log file i got
Errors in file E:\oracle\admin\wizerp\bdump\wizerpSNP3.TRC:
ORA-12012: error on auto execute of job 421
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 1
Sir can u please help in this regard?
Regards,
M.Shakeel Azeem
|
|
|
Re: dbms_stats.gather_schema_stats [message #197327 is a reply to message #197156] |
Wed, 11 October 2006 00:02 |
Mohammad Taj
Messages: 2412 Registered: September 2006 Location: Dubai, UAE
|
Senior Member |
|
|
ORA-12012: error on auto execute of job 421
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
above 06502 error is when varchar size is small let take a look
SQL> variable x varchar2(1)
SQL> begin
2 ' := 'xx';
3 end;
4 /
begin
*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 2
SQL> variable x varchar2(2);
SQL> begin
2 ' := 'xx';
3 end;
4 /
PL/SQL procedure successfully completed.
SQL>
Solution : Job no 421 raise error so remove this job.
sql>dbms_job.remove(421);
[Updated on: Wed, 11 October 2006 00:03] Report message to a moderator
|
|
|