RE: problem with GATHER_STATS_JOB
- From: Joe Smith <joe_dba@xxxxxxxxxxx>
- To: <testaj3@xxxxxxxxxxxxxx>
- Date: Wed, 16 Apr 2008 11:40:13 -0500
No. It shows up in user_objects and user_segments execute by the same user,
i.e. the schema owner.
To: joe_dba@xxxxxxxxxxxxx: oracle-l@xxxxxxxxxxxxx;
oracle-l-bounce@xxxxxxxxxxxxxxxxxxxx: Re: problem with GATHER_STATS_JOBFrom:
TESTAJ3@xxxxxxxxxxxxxxxxxx: Wed, 16 Apr 2008 12:22:42 -0400its 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 ExpensiveFast + Cheap will be
incorrect.Right + Cheap will take a while.
Joe Smith <joe_dba@xxxxxxxxxxx> Sent by: oracle-l-bounce@xxxxxxxxxxxxx
04/16/2008 12:15 PM Please respond to joe_dba@xxxxxxxxxxx
From
Joe Smith <joe_dba@xxxxxxxxxxx>
To
<oracle-l@xxxxxxxxxxxxx>
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.888ORA-20000: Unable to analyze INDEX
"SCHEMA"."F_MTH_MBR_RPT_METRICS_PK", insufficient privileges or does not
exist*** 2008-04-15 22:00:03.897GATHER_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 existthanks.
Use video conversation to talk face-to-face with Windows Live Messenger. Get
started!
_________________________________________________________________
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
Other related posts:
