Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Intermedia Text in 8.1.7.4
An expamle for you from when I was doing work on Intermedia..
You can set up different storages for different index sizes. In this case, the storage is called, simple "data_storage"
Ctx_Ddl.create_preference('data_storage', 'BASIC_STORAGE');
Ctx_Ddl.set_attribute('data_storage', 'I_TABLE_CLAUSE', 'TABLESPACE RECORD_DATA STORAGE (INITIAL 50M NEXT 50M)'); Ctx_Ddl.set_attribute('data_storage', 'K_TABLE_CLAUSE', 'TABLESPACE RECORD_DATA STORAGE (INITIAL 1M NEXT 1M)'); Ctx_Ddl.set_attribute('data_storage', 'R_TABLE_CLAUSE', 'LOB(DATA) STORE AS EMP_$R_LOB_SEGMENT (TABLESPACE LOB_DATA_INDX STORAGE (INITIAL 10M NEXT 10m) INDEX CFRS_$R_INDEX )TABLESPACE RECORD_DATA NOLOGGING PCTFREE 10 PCTUSED 60 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 4096 FREELISTS 1 FREELIST GROUPS 1 ) '); Ctx_Ddl.set_attribute('data_storage', 'N_TABLE_CLAUSE','TABLESPACE RECORD_DATA STORAGE (INITIAL 1M NEXT 1M)'); Ctx_Ddl.set_attribute('data_storage', 'I_INDEX_CLAUSE','TABLESPACE RECORD_INDX STORAGE (INITIAL 10M NEXT 100M)'); Ctx_Ddl.set_attribute('data_storage', 'P_TABLE_CLAUSE','TABLESPACE RECORD_DATA STORAGE (INITIAL 1M NEXT 1M)'); Received on Fri Jul 25 2003 - 15:20:34 CDT