Re: delete hangs

From: S Acharya <sujit_at_oil.asm.nic.in>
Date: Sat, 20 Jan 2001 07:32:33 +0530
Message-Id: <10746.127201@fatcity.com>

HiManivannan.

ANALYZE the table, index then try to delete. This should solve your problem. Sujit
----- Original Message -----
From: Manivannan.M <manivannan.m_at_tatainfotech.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, January 19, 2001 4:06 PM
Subject: delete hangs

> Hi Gurus,
>
> The problem that I am facing is that there is a table with 45 lakh records
> and the table has three indexes.Trying to delete a record from the table
> hangs.
>
> rgds,
> Manivannan
>
>
> Manivannan Muthukrishnan.
>
> --------------------------------------------------------------------------

---


>     ADDRESS:                             E-MAIL:

>     68/4, Site no:3,                     manivannan.m_at_tatainfotech.com

>     80 Feet road,

>     (opp) Deccan Studio,

>     Indiranagar,                         PHONE:

>     Bangalore - 560038.                  5284681  Ext: 464

> --------------------------------------------------------------------------

----


>

>

>

>

>

> --

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

> --

> Author: Manivannan.M

>   INET: manivannan.m_at_tatainfotech.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).

Received on Fri Jan 19 2001 - 20:02:33 CST