No, the procedure gathering statistics lives in the same schema of the
table being analyzed ...
anyway I tried even manually gathering, statistics in user_tables gets
compiled , in user_indexes not .. ??
On Dec 7, 2:44 am, joel garry <joel-ga..._at_home.com> wrote:
> On Dec 6, 7:42 am, nicola.far..._at_info-line.it wrote:
>
> > DBMS_STATS.GATHER_SCHEMA_STATS(user, METHOD_OPT => 'for all columns
> > size 1', CASCADE => True);
>
> > scheduled each day early morning
>
> It isn't ownname=>'SCOTT' or something? Sorry if you are just hiding
> the real name, but I had to ask, sometimes these things are simply
> correct-syntax-with-wrong-usage.
>
> jg
> --
> @home.com is bogus.
> "I promised myself I would never say 'Dude' on the air, but...Dude!' -
> radio announcer at Manhattan Beach, big waves.
Received on Fri Dec 07 2007 - 02:57:37 CST
