Home » SQL & PL/SQL » SQL & PL/SQL » Bitmap index creation problem
Bitmap index creation problem [message #365197] Wed, 08 April 1998 07:28 Go to next message
Lance
Messages: 2
Registered: April 1998
Junior Member
When I run the following statement, I get the index I expect.

create index mytable_test1
on myid.mytable (col_a)
tablespace indexts
STORAGE ( INITIAL 2M NEXT 256K MINEXTENTS 1
MAXEXTENTS 121 PCTINCREASE 0);

When I run this statement;

create bitmap index mytable$bitmap_test2
on myid.mytable (col_b)
tablespace indexts
STORAGE ( INITIAL 1M NEXT 128K MINEXTENTS 1
MAXEXTENTS 121 PCTINCREASE 0);

I get an error message ORA-00901 which translates as

ORA-00901 invalid CREATE command
Cause:
The CREATE command was not followed by a valid CREATE option.
Action:
Correct the syntax.

The only difference between the two is the BITMAP clause. I can't see what am I doing wrong (but I obviously am somewhere). Any sugestions? Ta.
Lance :-)
Re: BITMAP index creation problem [message #365378 is a reply to message #365197] Thu, 09 April 1998 17:26 Go to previous message
Manish Thawani
Messages: 6
Registered: April 1998
Junior Member
I hope you are not runing into one of these bugs related to bit map indexes.

PARALLEL QUERY OPTION has to be installed to create bitmapped indexes (see
BUG 388925).

there is another bug
bug 368132

Importing a dump file exported from 7.3 fails with ORA-901 "invalid CREATE
command". When a database is upgraded to 7.3.X, it causes the export views to
see the indexes as bitmapped indexes and thus converts the create unique
index statement to create bitmap index on export. This only occurs on
databases upgraded from the previous version, this has no effect on a database
newly created in V7.3.2.

Thanks!
Manish
Previous Topic: Long field to varchar datatype
Next Topic: PROCEDURE CALLED ERROR
Goto Forum:
  


Current Time: Thu Mar 28 16:54:11 CDT 2024