8i remote arch destinations...

From: Anjan Thakuria <Anjan.Thakuria_at_sabre.com>
Date: Fri, 19 Jan 2001 09:16:20 -0600
Message-Id: <10746.127144@fatcity.com>

Listers,

Can you please help me with this.

 Is there a feature built in 8i that will delete the archive logs once thay have been applied to a standby database?

 Also if the remote standby db is also a location for the archive logs will RMAN delete the arch logs on the
 standby server backed up?..

TIA Anjan

---

 From: S Jayakumar <sjayakumar2000_at_usa.net>  Date: 19 Jan 2001 08:24:01 MST
 Subject: Re: [delete hangs]

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

Received on Fri Jan 19 2001 - 09:16:20 CST