Xref: alice comp.databases.oracle.server:46029
Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!howland.erols.net!master.news.rcn.net!not-for-mail
From: ToneCzar@erols.com (Chris Hamilton)
Newsgroups: comp.databases.oracle.server
Subject: Re: Bitmap indexes
Date: Thu, 15 Apr 1999 14:36:30 GMT
Organization: City of Washington Pipe Band
Lines: 26
Message-ID: <3715f914.11182800@news.erols.com>
References: <7f4qb7$7mt$1@news.inet.tele.dk> <3715F7F1.121956A@removeme.bt.com>
Reply-To: toneczar@erols.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Trace: 4HrAr9WYsg21KMnh1d2Mop6KBwO4HKgEIHX9z1R52MdIDcgjopY5KQ==
X-Complaints-To: abuse@rcn.com
NNTP-Posting-Date: 15 Apr 1999 14:37:26 GMT
X-Newsreader:  Forte Agent 1.5/32.451

On Thu, 15 Apr 1999 15:30:10 +0100, Des Collins
<desmond.collins@removeme.bt.com> wrote:

>Ivan,
>
>If you run,
>
>select * from dba_indexes
>where uniqueness = 'BITMAP'
>
>this shows all bitmap indexes - and you can work on from there

That's not correct, at least not in 8.0.5.  There is an INDEX_TYPE
column.

select * from dba_indexes
where index_type = "BITMAP';

The UNIQUENESS column contains only the values UNIQUE and NONUNIQUE.

Chris
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Christopher Hamilton 
Oracle DBA -- Wall Street Sports
chris@wallstreetsports.com
http://www.wallstreetsports.com/