Local Index error on Bitmap Index type [message #281575] |
Sun, 18 November 2007 08:05 |
sheker2007
Messages: 19 Registered: November 2007
|
Junior Member |
|
|
Hello Experts,i need help...
I need to create local bitmap index on non partitioned table.
I am getting below error
ORA-14016: underlying table of a LOCAL partitioned index must be partitioned
CREATE BITMAP INDEX AFSDBOD.W_CHNG_IDX1 ON DBOD.W_CHNG(LN_TYPE)
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE XYZ_IDX_01
STORAGE(INITIAL 64K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
)
LOCAL
;
|
|
|
|
|
|
|
|