From oracle-l-bounce@freelists.org Wed Oct 6 23:04:28 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i9744R731304 for ; Wed, 6 Oct 2004 23:04:27 -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 i9744RI31299 for ; Wed, 6 Oct 2004 23:04:27 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F30CB72C4A3; Wed, 6 Oct 2004 23:10:32 -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 08192-90; Wed, 6 Oct 2004 23:10:32 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 677B072C498; Wed, 6 Oct 2004 23:10:32 -0500 (EST) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: RE: Function based indexes X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0 Date: Thu, 7 Oct 2004 09:38:28 +0530 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Function based indexes thread-index: AcSsIszxfc6JDuAgSo6q6FWSxdCmmwAAOUmw From: To: , X-OriginalArrivalTime: 07 Oct 2004 04:08:28.0537 (UTC) FILETIME=[4CCA3690:01C4AC23] X-archive-position: 10775 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: sanjay.khangarot@wipro.com Precedence: normal Reply-To: sanjay.khangarot@wipro.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org _IND_EXPRESSIONS can access DBA_ OR user_ or all_ , depends on your privs. Thanks and Regards=0D Sanjay -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Seema Singh Sent: Thursday, October 07, 2004 9:33 AM To: oracle-l@freelists.org Subject: Function based indexes=0D Hi, Which dictionary view show function based index column name and function=0D used at time of creation of function based indexes. dba_ind_columns show only SYS_NCxxxxxx. thanks -Seema _________________________________________________________________ Don't just search. Find. Check out the new MSN Search!=0D http://search.msn.click-url.com/go/onm00200636ave/direct/01/ -- http://www.freelists.org/webpage/oracle-l Confidentiality Notice=0D The information contained in this electronic message and any attachments to= this message are intended for the exclusive use of the addressee(s) and may contain confidential or= privileged information. If you are not the intended recipient, please notify the sender at Wipro or= Mailadmin@wipro.com immediately and destroy all copies of this message and any attachments. -- http://www.freelists.org/webpage/oracle-l