Re: problem with GATHER_STATS_JOB

You have a schema called "SCHEMA"?

ORA-20000 is an error raised by a PL/SQL procedure, not really an oracle error.

Finn

On 4/16/08, Riyaj Shamsudeen <riyaj.shamsudeen_at_gmail.com> wrote:
>
> Just a guess, are the schema or table statistics locked ?
>
> Thanks
> Riyaj
>
> On Wed, Apr 16, 2008 at 11:40 AM, Joe Smith <joe_dba_at_hotmail.com> wrote:
>
> > No. It shows up in user_objects and user_segments execute by the same
> > user, i.e. the schema owner.
> >
> > ------------------------------
> > To: joe_dba_at_hotmail.com
> > CC: oracle-l_at_freelists.org; oracle-l-bounce_at_freelists.org
> > Subject: Re: problem with GATHER_STATS_JOB
> > From: TESTAJ3_at_nationwide.com
> > Date: Wed, 16 Apr 2008 12:22:42 -0400
> >
> >
> >
> > its not one of those indexes "owned" by some other schema is it?
> >
> > Thanks, Joe
> >
> > ---------------------------------------
> > You can have it: Fast, Right or Cheap, pick 2 of the 3.
> > Fast + Right is Expensive
> > Fast + Cheap will be incorrect.
> > Right + Cheap will take a while.
> >
> >
> > *Joe Smith <joe_dba_at_hotmail.com>*
> >
> > *Sent by:** **oracle-l-bounce_at_freelists.org*
> >
> >
> >
> >
> > *04/16/2008 12:15 PM*
> > Please respond to joe_dba_at_hotmail.com From
> > *Joe Smith <joe_dba_at_hotmail.com>* To
> > <oracle-l_at_freelists.org> cc
> > Subject
> > problem with GATHER_STATS_JOB
> >
> >
> >
> >
> >
> > Has anybody ever seen this in their alert log before?
> > This is 10.2.0.3.0 EE on AIX 5.3L.
> > I don't see any note on metalink about it.
> >
> > The index exists in user_objects and user_segments.
> >
> >
> > *** ACTION NAME:(GATHER_STATS_JOB) 2008-04-15 22:00:03.888
> > *** MODULE NAME:(DBMS_SCHEDULER) 2008-04-15 22:00:03.888
> > *** SERVICE NAME:(SYS$USERS) 2008-04-15 22:00:03.888
> > *** SESSION ID:(463.126) 2008-04-15 22:00:03.888
> > ORA-20000: Unable to analyze INDEX "SCHEMA"."F_MTH_MBR_RPT_METRICS_PK",
> > insufficient privileges or does not exist
> > *** 2008-04-15 22:00:03.897
> > GATHER_STATS_JOB:
> > GATHER_INDEX_STATS('"SCHEMA"','"F_MTH_MBR_RPT_METRICS_PK"','""', ...)
> > ORA-20000: Unable to analyze INDEX "SCHEMA"."F_MTH_MBR_RPT_METRICS_PK",
> > insufficient privileges or does not exist
> >
> >
> > thanks.
> >
> >
> >
> > ------------------------------
> > Use video conversation to talk face-to-face with Windows Live Messenger.
> > *Get started!*<http://www.windowslive.com/messenger/connect_your_way.html?ocid=TXT_TAGLM_WL_Refresh_messenger_video_042008>
> >
> >
> >
> > ------------------------------
> > Get in touch in an instant. Get Windows Live Messenger now.<http://www.windowslive.com/messenger/overview.html?ocid=TXT_TAGLM_WL_Refresh_getintouch_042008>
> >
>
>

--
http://www.freelists.org/webpage/oracle-l