Re: problem with GATHER_STATS_JOB

From: <TESTAJ3_at_nationwide.com>
Date: Wed, 16 Apr 2008 12:22:42 -0400
Message-ID: <OF7EC4E6B0.725F6156-ON8525742D.0059F0B9-8525742D.0059F83F@lnotes-gw.ent.nwie.net>

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.freelists.org/webpage/oracle-l

Received on Wed Apr 16 2008 - 11:22:42 CDT