I did not catch this one the first time around, and I've had the exact same problem. Right now you've got a mess on your hands so I'd recommend opening an iTAR with OTS. They are going to have some VERY interesting questions to ask & if your not into messing about in the X$ tables your in for a real fright. The original problem was that while you were trying to drop the MV/snapshot it was trying to refresh. End result is a real mess down in the underlying data dictionary tables. OTS can guide you through the quagmire & get at the right points. They did for me.
Dick Goulet ____________________Reply Separator____________________ Author: "Reddy; Madhusudana" <[EMAIL PROTECTED]> Date: 4/30/2002 2:58 PM Yes I did. I am getting end of comunication channel error and then ORA-07445 in alert.log Any Idea ??? --Madhu -----Original Message----- Sent: Tuesday, April 30, 2002 3:59 PM To: Multiple recipients of list ORACLE-L encountered: did you try: drop snapshot .....? Waleed -----Original Message----- Sent: Tuesday, April 30, 2002 4:04 PM To: Multiple recipients of list ORACLE-L Hello ALL, I am having a problem in dropping an un-used Materialized view and getting the following error when I am trying to drop .... ORA-07445: exception encountered: core dump [kkzmtab()+76] [SIGSEGV] [Address not mapped to object] [588] [] [] I have found in metalink that it was a bug in 8.1.6 and is fixed in 8.1.7.... My DB is running on 8.1.7.2 But still I am unable to drop the MV , any ideas ??? Thanks in advance, Madhu V Reddy Database Support Services -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).