Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Intermedia Text in 8.1.7.4

Intermedia Text in 8.1.7.4

From: Thomas Troendlin <thomas.troendlin_at_kstm.sbs.de>
Date: Fri, 25 Jul 2003 05:41:46 GMT
Message-ID: <3f20ba66.620201@news.mch.sbs.de>


Hi

After enabling the context type indexes all seems to be working fine exept for one point. We are not able to use different tablepaces for the indexes than the default tablespace.

In the Oracle Documentation you can find the following storage parameters for setting up the Basic Storage.



begin
ctx_ddl.create_preference('mystore', 'BASIC_STORAGE'); ctx_ddl.set_attribute('mystore', 'I_TABLE_CLAUSE',

'tablespace foo storage (initial 1K)');
ctx_ddl.set_attribute('mystore', 'K_TABLE_CLAUSE',

'tablespace foo storage (initial 1K)');
ctx_ddl.set_attribute('mystore', 'R_TABLE_CLAUSE',

'tablespace foo storage (initial 1K)');
ctx_ddl.set_attribute('mystore', 'N_TABLE_CLAUSE',

'tablespace foo storage (initial 1K)');
ctx_ddl.set_attribute('mystore', 'I_INDEX_CLAUSE',

'tablespace foo storage (initial 1K)');
ctx_ddl.set_attribute('mystore', 'P_TABLE_CLAUSE',

'tablespace foo storage (initial 1K)');
end;


But it doesn´t work either.

Is anyone out there which have an good advice ?

Thank you

Thomas Received on Fri Jul 25 2003 - 00:41:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US