Re: DBMS_STATS "Missing expression"

From: Andreas Sheriff <spamcontrol_at_iion.com>
Date: Thu, 25 Aug 2005 12:48:42 -0700
Message-ID: <wgpPe.47005$Ji4.18664@fed1read03>

"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 

Received on Thu Aug 25 2005 - 14:48:42 CDT