RE: Using create index nologging?

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Tue, 20 Jul 2004 18:13:58 -0400
Message-ID: <KNEIIDHFLNJDHOOCFCDKEEBJFBAA.mwf@rsiz.com>

try a search for CREATE INDEX (I hope you don't have too many).

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Roger Xu Sent: Tuesday, July 20, 2004 5:53 PM
To: oracle-l_at_freelists.org
Subject: RE: Using create index nologging?

I_had_tried_both_upper_and_lower_cases_THANKYOU

-----Original=20Message-----
From:=20Bricklen=20Anderson=20[mailto:BAnderson_at_PresiNET.com] Sent:=20Tuesday,=20July=2020,=202004=204:50=20PM To:=20oracle-l_at_freelists.org
Subject:=20Re:=20Using=20create=20index=20nologging?

Roger=20Xu=20wrote:

>=20select_*_from_v$sqlare_where_sql_text_like_'%<index_name>%'
>=20returns_nothing_Can_somebody_explain_why?

case-sensitive?

--=20
Bricklen=20Anderson,=20Database=20Administrator PresiNET=20Systems
http://www.PresiNET.com
Online=20Demo:=20https://www.presinet.com/secure/login

This=20e-mail=20may=20be=20privileged=20and/or=20confidential,=20and=20the= =20sender=20does
not=20waive=20any=20related=20rights=20and=20obligations.=20Any=20distribu= tion,=20use=20or
copying=20of=20this=20e-mail=20or=20the=20information=20it=20contains=20by= =20other=20than=20the
intended=20recipient=20is=20unauthorized.=20If=20you=20have=20received=20t= his=20e-mail=20in
error,=20please=20advise=20me=20(by=20return=20e-mail=20or=20otherwise)=20= immediately.

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

To=20unsubscribe=20send=20email=20to:=20=20oracle-l-request_at_freelists.org put=20'unsubscribe'=20in=20the=20subject=20line.

--
Archives=20are=20at=20http://www.freelists.org/archives/oracle-l/
FAQ=20is=20at=20http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

For=20technical=20support=20please=20email=20tech_support_at_dp7uptx.com=20or=
=20you=20can
call=20(972)721-8257.=20
This=20email=20has=20been=20scanned=20for=20all=20viruses=20by=20the=20Mes=
sageLabs=20Email=20Security=20System.

************************************************************************
This=20e-mail=20is=20intended=20solely=20for=20the=20person=20or=20entity=20
=
to=20which=20it=20is=20addressed=20and=20may=20contain=20confidential=20an=
d/or=20privileged=20information.=20Any=20review,=20dissemination,=20copyin=
g,=20printing=20or=20other=20use=20of=20this=20e-mail=20by=20persons=20or=20
=
entities=20other=20than=20the=20addressee=20is=20prohibited.=20If=20you=20=
have=20received=20this=20e-mail=20in=20error,=20please=20contact=20the=20s=
ender=20immediately=20and=20delete=20the=20material.=20
************************************************************************
This=20email=20has=20been=20scanned=20for=20all=20viruses=20by=20the=20Mes=
sageLabs=20Email=20Security=20System.=20Any=20questions=20please=20call=20=
972-721-8257=20or=20email=20your=20request=20to=20tech_support_at_dp7uptx.com=
.
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Jul 20 2004 - 17:10:36 CDT