It was the "alter system set current_schema=x" statement after all.
I am sure that this raises some interesting questions, if only I had time to dwell on it. Just now cleaning up all the broken indexes from the loads that abended when the db went down. I love this job. Where else do you get to play at work? jack > --- Jack Silvey <[EMAIL PROTECTED]> wrote: > > All, > > > > thanks for the input. Looks like someone > implemented > > a > > login trigger. haven't seen the code yet, but I > > would > > venture a guess he used the unsupported "alter > > system > > set current_schema=x". > > > > sometimes you live and learn, sometimes you just > > live! > > > > thx, > > > > jack silvey > > > > > > --- Hately Mike <[EMAIL PROTECTED]> wrote: > > > I don't hold out much hope here Jack. > > > It sounds like data dictionary corruption; maybe > > > somewhere round user$(?). > > > That's not to say the situation's irretrievable; > > > I've seen OTS fix some bad > > > situations in my time but I'm not sure that I'd > > want > > > to keep the database > > > even if Oracle Support can fix the problem. > > > > > > Regards, > > > Mike > > > > > > -----Original Message----- > > > Sent: 12 June 2002 14:23 > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > Listers, > > > > > > Our warehouse now has a split personality and we > > > have > > > a sev1 open on it. Suspect recovery is in the > > cards, > > > but want to avoid if possible. > > > > > > Yesterday, users unable to get to their own > > > functions. > > > Soon after, RMAN cannot find package > > > dbms_backup_restore, even though it exists under > > > sys. > > > Oncall ran the sql script to recreate - and the > > > pacakge was recreated under a schema called > > > dma_rbate2. RMAN now finds the package under > > > dma_rbate2, although it is invalid. Drop the > > package > > > under dma_rbate2, and now RMAN cannot find the > > > package > > > any longer, although it still exists under sys. > > > > > > Logged in as sys. Tried to desc > > dbms_backup_restore > > > - > > > no luck. Tried to desc sys.dbms_backup_restore - > > > success. > > > > > > Analyst reccomends running catalog.sql. Oncall > > does > > > so, and it creates as many packages as it is > able > > > under dma_rbate2. > > > > > > I get up this AM and can't login, because the > > > sessions > > > can't find the package > > > dma_rbate2.dbms_application_info. > > > > > > Anyone? Buhler? Buhler? > > > > > > thx, > > > > > > jack > > > > > > > > > > > > > > > ____________________________________________________________________________ > > > ________________________ > > > > > > This email and any attached to it are > confidential > > > and intended only for the > > > individual or > > > entity to which it is addressed. If you are not > > the > > > intended recipient, > > > please let us know > > > by telephoning or emailing the sender. You > should > > > also delete the email and > > > any attachment > > > from your systems and should not copy the email > or > > > any attachment or > > > disclose their content > > > to any other person or entity. The views > > expressed > > > here are not necessarily > > > those of > > > Churchill Insurance Group plc or its affiliates > or > > > subsidiaries. Thank you. > > > Churchill Insurance Group plc. Company > > Registration > > > Number - 2280426. > > > England. > > > Registered Office: Churchill Court, Westmoreland > > > Road, Bromley, Kent BR1 > > > 1DP. > > > > > > > > > -- > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.com > > > -- > > > Author: Hately Mike > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services -- (858) 538-5051 > > FAX: > > > (858) 538-5051 > > > San Diego, California -- Public Internet > > > access / Mailing Lists > > > > > > -------------------------------------------------------------------- > > > 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). > > > > > > __________________________________________________ > > Do You Yahoo!? > > Yahoo! - Official partner of 2002 FIFA World Cup > > http://fifaworldcup.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Jack Silvey > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- (858) 538-5051 > FAX: > > (858) 538-5051 > > San Diego, California -- Public Internet > > access / Mailing Lists > > > -------------------------------------------------------------------- > > 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). > > ===== > Connor McDonald > http://www.oracledba.co.uk > http://www.oaktable.net > > "Some days you're the pigeon, some days you're the > statue" > > __________________________________________________ > Do You Yahoo!? > === message truncated === __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack Silvey INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
