Re: Intermedia Text in 8.1.7.4

From: Anton Buijs <remove_aammbuijs_at_xs4all.nl>
Date: Fri, 25 Jul 2003 21:33:55 +0200
Message-ID: <3f218640$0$49113$e4fe514c@news.xs4all.nl>

Thomas Troendlin <thomas.troendlin_at_kstm.sbs.de> schreef in berichtnieuws 3f20ba66.620201_at_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
|

When you create the index you must specify that this datastore must be used, for example:

    create index myindex on mytable(docs)

        indextype is ctxsys.context
        parameters ('storage mystore');

The keyword "storage" as the parameter is not in the document, indead. I wanted to say that initial 1K is not a smart value, but I recognised it as the example that is in the book.
I can't imagine Oracle uses such a bad value in its examples (and it's impossible because the initial extent of a table must be at least 2 Oracle blocks!)
When you are on V8.1.7.3 or V8.1.7.4 or V9.2.x use locally managed tablespaces (uniform or autoallocate) so the tablespace chooses the extent sizes. Received on Fri Jul 25 2003 - 14:33:55 CDT