RE: strange error on DBMS_STATS

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_at_qtiworld.com              Quad/Tech International, Sussex, WI USA

> -----Original Message-----
> From: Rachel Carmichael [mailto:wisernet100_at_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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.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_at_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).