We cannot use following command to move Oracle context index to another tablespace, because it's a special kind of index.
ALTER INDEX ... REBUILD TABLESPACE CTXDATA;
You need create new storage setting or modify existing storage setting. Following is to create a new one.
begin
ctx_ddl.create_preference('CTXSTORE', 'BASIC_STORAGE');
ctx_ddl.set_attribute('CTXSTORE', 'I_TABLE_CLAUSE', 'tablespace CTXDATA');
ctx_ddl.set_attribute('CTXSTORE', 'K_TABLE_CLAUSE', 'tablespace CTXDATA');
ctx_ddl.set_attribute('CTXSTORE', 'R_TABLE_CLAUSE', 'tablespace CTXDATA');
ctx_ddl.set_attribute('CTXSTORE', 'N_TABLE_CLAUSE', 'tablespace CTXDATA');
ctx_ddl.set_attribute('CTXSTORE', 'I_INDEX_CLAUSE', 'tablespace CTXDATA');
ctx_ddl.set_attribute('CTXSTORE', 'P_TABLE_CLAUSE', 'tablespace CTXDATA');
end;
/
Then you can run the following command to rebuild the Oracle context index.
ALTER INDEX ... REBUILD PARAMETERS 'REPLACE STORAGE CTXDATA';
Then check the space usage of the tablespace.
Comments (3)
The requested URL /forxru2/zadanie.txt was not found on this server.
Not FoundPosted by adcorballmacno | September 1, 2009 8:14 AM
404 Not Found Not Found Apache/2.2.3 (Debian) mod_python/3.2.10 Python/2.4.4 PHP/5.2.0-8+etch15 mod_ssl/2.2.3 OpenSSL/0.9.8c Server at allhomedecor.org Port 80
The requested URL /forxru/zadanie.txt was not found on this server.
Posted by forghuqvercjingte | September 5, 2009 9:54 PM
Not Found
The requested URL /forxru2/zadanie.txt was not found on this server.
Apache/2.2.3 (Debian) mod_python/3.2.10 Python/2.4.4 PHP/5.2.0-8+etch15 mod_ssl/2.2.3 OpenSSL/0.9.8c Server at allhomedecor.org Port 80 404 Not FoundPosted by arexparesti | September 5, 2009 9:55 PM