Rachel Carmichael wrote: > > 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 >
I have not seen it but could the rebuilt index now have a different owner ? -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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).
