From oracle-l-bounce@freelists.org Tue Jul 20 17:10:36 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6KMABr01505 for ; Tue, 20 Jul 2004 17:10:21 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i6KMA0601482 for ; Tue, 20 Jul 2004 17:10:11 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 50F3E72D576; Tue, 20 Jul 2004 16:49:25 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24980-27; Tue, 20 Jul 2004 16:49:25 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9CF0172D565; Tue, 20 Jul 2004 16:49:24 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 20 Jul 2004 16:47:56 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id AAFC072D566 for ; Tue, 20 Jul 2004 16:47:55 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 23530-98 for ; Tue, 20 Jul 2004 16:47:55 -0500 (EST) Received: from troll.tpk.net (mail.tpk.net [216.107.198.11]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 63C8F72D577 for ; Tue, 20 Jul 2004 16:47:54 -0500 (EST) Received: from MWF600XL (host216-107-212-43.tpk.net [216.107.212.43]) by troll.tpk.net (Postfix) with SMTP id 9988C669111 for ; Tue, 20 Jul 2004 18:13:47 -0400 (EDT) From: "Mark W. Farnham" To: Subject: RE: Using create index nologging? Date: Tue, 20 Jul 2004 18:13:58 -0400 Message-ID: MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 In-Reply-To: Importance: Normal X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 5566 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mwf@rsiz.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org try a search for CREATE INDEX (I hope you don't have too many). -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Roger Xu Sent: Tuesday, July 20, 2004 5:53 PM To: oracle-l@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@PresiNET.com] Sent:=20Tuesday,=20July=2020,=202004=204:50=20PM To:=20oracle-l@freelists.org Subject:=20Re:=20Using=20create=20index=20nologging? Roger=20Xu=20wrote: >=20select_*_from_v$sqlare_where_sql_text_like_'%%' >=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@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@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@dp7uptx.com= . ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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@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 -----------------------------------------------------------------