Re: problems making bitmap index

From: robie <rlaarhoven_at_sql-integrator.nl>
Date: Sat, 17 Jul 1999 10:46:02 +1000
Message-ID: <932201478.612259_at_newsreader1.wirehub.nl>


Hi there,

Did you check the "compatible" parameter in the init.ora. It must be 7.2.3 or higher.

Rob

>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);
Received on Sat Jul 17 1999 - 02:46:02 CEST

Original text of this message