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" <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] Quad/Tech International, Sussex, > WI USA > > > > -----Original Message----- > > From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] > > 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
