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