Oracle-L: Re:RE: Problem in Dropping a MV : ORA-07445: exception

From: <dgoulet_at_vicr.com>
Date: Wed, 01 May 2002 06:03:25 -0800
Message-ID: <F001.00454CD2.20020501060325@fatcity.com>

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" <Madhusudana.Reddy_at_bestbuy.com>
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: Madhusudana.Reddy_at_bestbuy.com

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: 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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Khedr, Waleed
INET: Waleed.Khedr_at_FMR.COM

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Reddy, Madhusudana
INET: Madhusudana.Reddy_at_bestbuy.com

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: dgoulet_at_vicr.com

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