IOT concepts
706831Nov 21 2009 — edited Nov 26 2009I have one doubt: whenever I run below script to create Mapping table IOT, doest it mean that Bitmap index will be created on MYIDX tablespace?
CREATE TABLE IOT_TABLE_MAP
(
EID NUMBER(38),
ENAME VARCHAR2(50 BYTE),
ADDRESS VARCHAR2(50 BYTE),
PHONE VARCHAR2(50 BYTE),
MID NUMBER(38) CONSTRAINT NN2 NOT NULL,
CONSTRAINT PK2
PRIMARY KEY
(EID)
)
ORGANIZATION INDEX
MAPPING TABLE
LOGGING
TABLESPACE MYIDX
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 128K
NEXT 128K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
PCTTHRESHOLD 20
NOPARALLEL
MONITORING;