problems making bitmap index

From: <shockerman_at_my-deja.com>
Date: Fri, 16 Jul 1999 16:22:11 GMT
Message-ID: <7mnm74$jof$1_at_nnrp1.deja.com>



[Quoted] I have Oracle 7.3.2.3.1 as shown here:

SQL*Plus: Release 3.3.2.0.2 - Production on Fri Jul 16 10:37:29 1999 Copyright (c) Oracle Corporation 1979, 1994. All rights reserved. Connected to:
Oracle7 Workgroup Server Release 7.3.2.3.1 - Production Release With the distributed option
PL/SQL Release 2.3.2.3.0 - Production

I'm trying to create a bitmap index on a table. I can create a regular index fine, but when I go to create a bitmap index. I get the error "invalid create command". In Oracle 8: The Complete reference, Koch says that Bitmap indexes are available as of Oracle7.3. Anyone know what's up? Here's my create statement:

create bitmap index bitter on logtable (rid);

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jul 16 1999 - 18:22:11 CEST

Original text of this message