Home » RDBMS Server » Server Administration » dbms_stats.gather_schema_stats
dbms_stats.gather_schema_stats [message #197156] Tue, 10 October 2006 05:15 Go to next message
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 Go to previous message
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 'Mad := '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 'Mad := '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

Previous Topic: ORA-01157 on database startup
Next Topic: Cannot Cpen Database
Goto Forum:
  


Current Time: Mon Dec 05 06:40:02 CST 2016

Total time taken to generate the page: 0.08629 seconds