RE: Function based indexes

From: <sanjay.khangarot_at_wipro.com>
Date: Thu, 7 Oct 2004 09:38:28 +0530
Message-ID: <C1F81E780BC53D44A7C55DC6633F841404BDDE0D@blr-ec-msg05.wipro.com>

_IND_EXPRESSIONS
can access DBA_ OR user_ or all_ , depends on your privs.

Thanks and Regards=0D

Sanjay

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Seema Singh Sent: Thursday, October 07, 2004 9:33 AM To: oracle-l_at_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_at_wipro.com immediately
and destroy all copies of this message and any attachments.
--

http://www.freelists.org/webpage/oracle-l Received on Wed Oct 06 2004 - 23:04:28 CDT