Re: DBMS_STATS "Missing expression"

Andreas Sheriff wrote:
> "Mark D Powell" <Mark.Powell_at_eds.com> wrote in message
> news:1124996740.359404.158710_at_g14g2000cwa.googlegroups.com...
> > Only thing I found of interest on metalink was bug 3491127 (document
> > id) which appears to be for 9.2 where a multi-columned index on a
> > partitioned table could produce this error
> >
> > Have you verified that no one reran catproc under the wrong id? If
> > some of the sys owned objects were invalid or the public synonyms
> > pointed to the wrong owner then cleaning up the mess should resolve
> > this, but only if someone messed up.
> >
> > That is all I can think of other than trying to get around the problem,
> > assuming it is reproducing, by generating gather_table_stats calls for
> > the schema.
> >
> > HTH -- Mark D Powell --
> >
>
> No one re-ran catproc under any id.
>
> We are not using partitions.
>
> Doing a SELECT DISTINCT STATUS FROM DBA_OBJECTS;
> returns only
> STATUS
> ---------
> VALID
>
> The error is reproduced using:
> EXEC DBMS_STATS.GATHER_SCHEMA_STATS( ownname=>'SCHEMANAME' );
>
> However, I do remember
> creating SYSTEM.PLAN_TABLE (using the SYSTEM account),
> creating a PUBLIC SYNONYM PLAN_TABLE FOR SYSTEM.PLAN_TABLE (using the as
> sysdba privileges) and
> granting appropriate privileges for PLAN_TABLE to public.
>
> Querying dba_tab_privs, I see that the privileges granted to PUBLIC for
> PLAN_TABLE are ALTER, DELETE, INDEX, INSERT, SELECT, UPDATE, and REFERENCES.
>
> That can't be what's $cr3wing up DBMS_STATS, is it?
>
> --
> Andreas
> Oracle 9i Certified Professional
> Oracle 10g Certified Professional
> Oracle 9i Certified PL/SQL Developer
>
>
> "If you don't eat your meat, you cannot have any pudding.
> "How can you have any pudding if you don't eat your meat?!?!"
> ---
>
> WARNING:
> DO NOT REPLY TO THIS EMAIL
> Reply to me only on this newsgroup

You could drop the table and find out. You could also trace the session running dbms_stats.

David Fitzjarrell Received on Thu Aug 25 2005 - 16:58:17 CDT