Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: [delete hangs]

Re: [delete hangs]

From: S Jayakumar <sjayakumar2000_at_usa.net>
Date: 19 Jan 2001 08:24:01 MST
Message-Id: <10746.127145@fatcity.com>


the where condition U R giving for deletion may not use any of the three indexes & may lead to a full table scan until the row is found(which may = take
a long time - seems to be hanging). Please check Ur indexes.

Jay

"Manivannan.M" <manivannan.m_at_tatainfotech.com> wrote: Hi Gurus,

The problem that I am facing is that there is a table with 45 lakh record= s
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).

Get free email and a permanent address at http://www.netaddress.com/?N=3D= 1

 From: lerobe - Lee Robertson <LEROBE_at_acxiom.co.uk>  Date: Fri, 19 Jan 2001 15:21:44 -0000
 Subject: RE: Export of Tables with lower case characters in the name.

Nope - thanks again though

> Lee Robertson
> Acxiom
> Tel: 	0191 525 7344
> Fax: 	0191 525 7007
> Email: lerobe_at_acxiom.co.uk
> 


-----Original Message-----

From: Vadim Gorbounov [mailto:vgorbounov_at_simplyengineering.com] Sent: 19 January 2001 14:51
To: Multiple recipients of list ORACLE-L Subject: RE: Export of Tables with lower case characters in the name.

        Try to use this
exp .... tables='("tab1","tab2"...,"tabn")'

	Vadim Gorbounov
	Oracle DBA

-----Original Message-----

Sent: Thursday, January 18, 2001 7:47 AM To: Multiple recipients of list ORACLE-L

I have never tried it but you can try

exp .... tables=("tab1","tab2"...,"tabn")

Rick

> -----Original Message-----
> From:	lerobe - Lee Robertson [SMTP:LEROBE_at_acxiom.co.uk]
> Sent:	Thursday, January 18, 2001 5:46 AM
> To:	Multiple recipients of list ORACLE-L
> Subject:	Export of Tables with lower case characters in the name.
> 
> All,
>  
> One of the applications here has hard coded tablenames of mixed case. How
> do
> I get the export command to recognise the mixed case tablenames. At the
> moment it is coming back with the tablename (in upper case) not
> recognised. 
>  
> TIA 
>  
> Lee
>  
> 
> 
> The information contained in this communication is
> confidential, is intended only for the use of the recipient
> named above, and may be legally privileged. If the reader 
> of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or
> copying of this communication is strictly prohibited.  
> If you have received this communication in error, please 
> re-send this communication to the sender and delete the 
> original message or any copy of it from your computer
> system.
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: lerobe - Lee Robertson
>   INET: LEROBE_at_acxiom.co.uk
> 
> 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: Cale, Rick T (Richard)
  INET: RICHARD.T.CALE_at_saic.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: Vadim Gorbounov INET: vgorbounov_at_simplyengineering.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).
------------------------------
From: "Nelson, Greg" <GNelson_at_banknorth.com> Date: Fri, 19 Jan 2001 10:32:11 -0500 Subject: RE: How to see the threads of a oracle process on NT Server? This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.
------_=_NextPart_000_01C0822C.FE01F74C
Content-Type: text/plain; charset="iso-8859-1" Install Oracle Administration Assistant for Windows NT. It requires installing Microsoft's Management Console (MMC). The Administration Assistant is a snapin for MMC. Then, you can view the threads (see attached jpeg): From: gnelson_at_banknorth.com
-----Original Message-----
Received on Fri Jan 19 2001 - 09:24:01 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US