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_at_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_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
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_at_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_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).
Received on Thu Dec 19 2002 - 11:34:29 CST