Index creation in context

Hi,

When I create a context index ,it is always created in the System tablespace.

Is it the default or there is any way of modifying it.

My second question is if Oracle indexes(btree)and context indexes are in the same tablespace is there aproblem?


Thanks

Anand Devaraj

first off all, a context index is a combination of different 'real' tables and indexes.

Where the different segments are created, and what the storage parameters are, that you must define in the attributes off the context index.

example taken from our creation script.
just the storage part :

ctx_ddl.set_attribute ('INDEX_MEMORY', 40000000 );
---------------
-- I1T
---------------
ctx_ddl.set_attribute ('I1T_TABLESPACE', 'ORADATA' );
ctx_ddl.set_attribute ('I1T_STORAGE',' INITIAL 33550336 NEXT 33550336 MAXEXTENTS 249 PCTINCREASE 0');
ctx_ddl.set_attribute ('I1T_OTHER_PARMS',' PCTFREE 20');
ctx_ddl.set_attribute ('I1T_OTHER_PARMS',' PARALLEL 2');

ctx_ddl.set_attribute ('I1I_TABLESPACE', 'ORAINDEX');
ctx_ddl.set_attribute ('I1I_STORAGE', ' INITIAL 33550336 NEXT 33550336 MAXEXTENTS 249 PCTINCREASE 0');
ctx_ddl.set_attribute ('I1I_OTHER_PARMS',' PARALLEL 2');
ctx_ddl.set_attribute ('I1I_OTHER_PARMS',' PCTFREE 10');
---------------
-- KTB
---------------
ctx_ddl.set_attribute ('KTB_TABLESPACE', 'ORADATA' );
ctx_ddl.set_attribute ('KTB_STORAGE',' INITIAL 520192 NEXT 520192 MAXEXTENTS 249 PCTINCREASE 0');
ctx_ddl.set_attribute ('KTB_OTHER_PARMS',' PCTFREE 20');

ctx_ddl.set_attribute ('KID_TABLESPACE', 'ORAINDEX');
ctx_ddl.set_attribute ('KID_STORAGE', ' INITIAL 520192 NEXT 520192 MAXEXTENTS 249 PCTINCREASE 0');
ctx_ddl.set_attribute ('KID_OTHER_PARMS',' PARALLEL 2');
ctx_ddl.set_attribute ('KID_OTHER_PARMS',' PCTFREE 10');

ctx_ddl.set_attribute ('KIK_TABLESPACE', 'ORAINDEX');
ctx_ddl.set_attribute ('KIK_STORAGE', ' INITIAL 520192 NEXT 520192 MAXEXTENTS 249 PCTINCREASE 0');
ctx_ddl.set_attribute ('KIK_OTHER_PARMS',' PARALLEL 2');
ctx_ddl.set_attribute ('KIK_OTHER_PARMS',' PCTFREE 10');

---------------
-- LST
---------------
ctx_ddl.set_attribute ('LST_TABLESPACE', 'ORADATA' );
ctx_ddl.set_attribute ('LST_STORAGE',' INITIAL 520192 NEXT 520192 MAXEXTENTS 249 PCTINCREASE 0');
ctx_ddl.set_attribute ('LST_OTHER_PARMS',' PCTFREE 20');

ctx_ddl.set_attribute ('LIX_TABLESPACE', 'ORAINDEX');
ctx_ddl.set_attribute ('LIX_STORAGE', ' INITIAL 520192 NEXT 520192 MAXEXTENTS 249 PCTINCREASE 0');
ctx_ddl.set_attribute ('LIX_OTHER_PARMS',' PARALLEL 2');
ctx_ddl.set_attribute ('LIX_OTHER_PARMS',' PCTFREE 10');
---------------
-- SQR
---------------
ctx_ddl.set_attribute ('SQR_TABLESPACE', 'ORADATA' );
ctx_ddl.set_attribute ('SQR_STORAGE',' INITIAL 520192 NEXT 520192 MAXEXTENTS 249 PCTINCREASE 0');
ctx_ddl.set_attribute ('SQR_OTHER_PARMS',' PCTFREE 20');

ctx_ddl.set_attribute ('SRI_TABLESPACE', 'ORAINDEX');
ctx_ddl.set_attribute ('SRI_STORAGE', ' INITIAL 520192 NEXT 520192 MAXEXTENTS 249 PCTINCREASE 0');
ctx_ddl.set_attribute ('SRI_OTHER_PARMS',' PARALLEL 2');
ctx_ddl.set_attribute ('SRI_OTHER_PARMS',' PCTFREE 10');


--> all the 'context index tables' are created in tablespace ORADATA
--> all the 'context index indexes' are create in tablespace ORAINDEX

Hope this helps
Gert

Hi Gert,

Thanks for your detailed reply . I'll get back to you after I have tried these changes.


Regards

Anand