Hello people,
I have the strange behavior when executing the below in 11g.
It Was working a few days ago.:
exec STAGE.STATS.gather_stats_int;
ORA-27486: insufficient privileges
ORA-06512: in "SYS.DBMS_STATS", line 25335
ORA-06512: in "SYS.DBMS_STATS", line 25414
ORA-06512: in "SYS.DBMS_STATS", line 25367
ORA-06512: in "STAGE.STDB_STATS_PKG", line 183
ORA-06512: in line 1
Contents:
...
Procedure gather_stats_int is
Begin
begin
dbms_stats.gather_schema_stats(
ownname => 'INT',
estimate_percent => dbms_stats.auto_sample_size,
method_opt => 'for all indexed columns',
degree => DBMS_STATS.AUTO_DEGREE
);
end;
End;
...
While EXEC the above part it works ok.
Any idea what might cause it ?
Thank you in advance.