RE: Oracle 11g - Invisible Indexes

From: Robert Freeman <robertgfreeman_at_yahoo.com>
Date: Sun, 12 Aug 2007 21:13:40 -0600
Message-ID: <KEEDIPJOJLCHPPAIDPDOEEEPEEAA.robertgfreeman@yahoo.com>

You are correct. A rebuild of the index does make it visible. You do not need to change any init.ora parameters to use this feature (except compatible of course).

Robert G. Freeman
Oracle Consultant/DBA/Author
Principal Engineer/Team Manager
The Church of Jesus Christ of Latter-Day Saints Father of Five, Husband of One,
Author of various geeky computer titles
from Osborne/McGraw Hill (Oracle Press)
Oracle Database 11g New Features Now Available for Pre-sales on Amazon.com! BLOG: http://robertgfreeman.blogspot.com/ Sig V1.2

  -----Original Message-----
  From: Sanjay Mishra [mailto:smishra_97_at_yahoo.com]   Sent: Sunday, August 12, 2007 7:36 PM
  To: robertgfreeman_at_yahoo.com; oracle-l_at_freelists.org   Subject: Re: Oracle 11g - Invisible Indexes

Robert

I was looking for the same feature on onew of the link http://www.datasoftech.com/library/DSI_11g_Inv.pdf

and found that it is been referred as feature and it will only availble when one of the init.ora is not Eanbled.

I like this document but One point I didn't got in the doc is that it says that if you Rebuild the index it will make it visible. Have you noticed this fact as I am going to download 11g tomorrow and try it.

Is it a bug or is there any Rebuild option that can still keep it Invisible. I am not able to find the option in Doc listed on OTN.

Sanjay

Robert Freeman <robertgfreeman_at_yahoo.com> wrote: On my blog now, 11g New Feature, Invisible Indexes.

http://robertgfreeman.blogspot.com/

Enjoy!!

    Robert G. Freeman
    Oracle Consultant/DBA/Author
    Principal Engineer/Team Manager
    The Church of Jesus Christ of Latter-Day Saints     Father of Five, Husband of One,
    Author of various geeky computer titles     from Osborne/McGraw Hill (Oracle Press)     Oracle Database 11g New Features Now Available for Pre-sales on Amazon.com!

BLOG: http://robertgfreeman.blogspot.com/ Sig V1.2

--
http://www.freelists.org/webpage/oracle-l

--

Building a website is a piece of cake. Yahoo! Small Business gives you all the tools to get online.

--

http://www.freelists.org/webpage/oracle-l Received on Sun Aug 12 2007 - 22:13:40 CDT