DBMS - Jobs getting failure
846280Apr 26 2011 — edited Apr 28 2011Hi All,
One of the dbms jobs getting failure!!. I have been assigned this job via OEM. The job description is like..
DECLARE
BEGIN
dbms_stats.gather_schema_stats(ownname=>'INSEG',METHOD_OPT=>'FOR ALL COLUMNS SIZE AUTO',CASCADE=>TRUE,ESTIMATE_PERCENT=>100);
END;
BEGIN
dbms_stats.gather_schema_stats(ownname=>'INSEG_READONLY',METHOD_OPT=>'FOR ALL COLUMNS SIZE AUTO',CASCADE=>TRUE,ESTIMATE_PERCENT=>100);
END;
And this job has to run daily morning. But 'm getting the error message like
ORA-00900: invalid SQL statement ORA-06512: at "SYS.DBMS_STATS", line 20508 ORA-06512: at "SYS.DBMS_STATS", line 20993 ORA-06512: at "SYS.DBMS_STATS", line 21073 ORA-06512: at "SYS.DBMS_STATS", line 21030 ORA-06512: at line 3
Friends, can you please help me to fix this issue.
Regards,
Sijo