| Bitmap index creation problem [message #365197] |
Wed, 08 April 1998 07:28  |
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  |
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
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
