RE: Shadow Indexes
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <jkstill@xxxxxxxxx>, "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 28 Sep 2006 18:21:32 -0400
The magic phrase is 'NOSEGMENT'.
But, if you're on 9.2.0.x and x < 8, don't create a bitmap nosegment
index, or you won't be able to drop it. ;-)
(Just hit that bug, and applied the 9.2.0.8 patch yesterday to fix the
problem.)
-Mark
--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning
For a successful technology, reality must take precedence over public
relations, for Nature cannot be fooled. --Richard P. Feynman, 1918-1988
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still
Sent: Thursday, September 28, 2006 6:20 PM
To: Oracle-L Freelists
Subject: Shadow Indexes
Does someone here recall the syntax for creating metadata only indexes?
This for use by the SQL tuning advisors, etc.
I can't recall the syntax, and cannot find it.
Thanks,
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
