Message-ID: <F001.0051E8AA.20021219093429@fatcity.com>
Date: Thu, 19 Dec 2002 09:34:29 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: Rachel Carmichael <wisernet100@yahoo.com>
Subject: RE: strange error on DBMS_STATS
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

this is being run in sqlplus as 

execute dbms_stats.gather_schema_stats

If I didn't run it (on another schema) within the same sql script, I'd
think it was that I didn't have privs on dbms_stats.

I'll keep looking


--- "Jesse, Rich" <Rich.Jesse@qtiworld.com> wrote:
> Yes, but it turned out to be privs (or lack thereof) to run the stats
> or
> associated queries in a procedure, rather than privs to do the
> analyze
> itself.  Do you have auditing turned on?  That's usually the first
> place I
> check to see what objects changed since the last time it worked.
> 
> GL!
> 
> Rich
> 
> 
> Rich Jesse                           System/Database Administrator
> Rich.Jesse@qtiworld.com              Quad/Tech International, Sussex,
> WI USA
> 
> 
> > -----Original Message-----
> > From: Rachel Carmichael [mailto:wisernet100@yahoo.com]
> > Sent: Thursday, December 19, 2002 10:39 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: strange error on DBMS_STATS
> > 
> > 
> > I'm running dbms_stats.gather_schema_stats, the account running it
> is
> > NOT the schema owner, but DOES have the "analyze any" 
> > privilege and has
> > read/write access to all the tables in the schema. We are not 
> > trying to
> > gather stats into our own tables, just want the stats refreshed
> after
> > the (massive) loads into the DW tables.
> > 
> > This has been running fine, then all of a sudden last night we
> started
> > getting ORA-1031 ("insufficient privileges") errors. Now, according
> to
> > the docs:
> > 
> > ORA-01031 insufficient privileges
> > 
> >     Cause: An attempt was made to change the current username or
> > password without the appropriate privilege. This error also occurs
> if
> > attempting to install a database without the necessary 
> > operating system
> > privileges.
> > 
> > 
> > We are not changing passwords, so I am presuming that this involves
> > (somehow) a change of username. According to the package header, it
> > will throw an ORA-20000 if there are insufficent privileges. 
> > We rebuilt
> > an index yesterday but did NOT change or add any table.
> > 
> > I had this happen once before, on a different database, never
> solved
> > it, but substituted dbms_utility.analyze_schema which worked. I can
> do
> > the same thing this time but I'd prefer to solve it.
> > 
> > Anyone ever see anything like this before?
> > 
> > oh yeah  9.2.0.1 on Solaris 8
> > 
> > Rachel


__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rachel Carmichael
  INET: wisernet100@yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).