Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 592
  • Last Modified:

How to move domain (CLOB) index from one tablespace to another

Hi ,
I need to move some of the domain (CLOB) index from one tablespace to another. how can I move.
0
dba1234
Asked:
dba1234
  • 3
2 Solutions
 
slightwv (䄆 Netminder) Commented:
Is this an Oracle Text index?

If so you can name the tablespaces for the various pieces by creating a storage preference then using it to build the index.  See the example below.

If you mean some other index, please let us know the type.



begin
	ctx_ddl.create_preference('MY_STORAGE', 'BASIC_STORAGE');
	ctx_ddl.set_attribute('MY_STORAGE', 'I_TABLE_CLAUSE', 'tablespace ctx_objects');
	ctx_ddl.set_attribute('MY_STORAGE', 'K_TABLE_CLAUSE', 'tablespace ctx_objects');
	ctx_ddl.set_attribute('MY_STORAGE', 'R_TABLE_CLAUSE', 'tablespace ctx_objects lob (data) store as (disable storage in row cache)');
	ctx_ddl.set_attribute('MY_STORAGE', 'N_TABLE_CLAUSE', 'tablespace ctx_objects');
	ctx_ddl.set_attribute('MY_STORAGE', 'I_INDEX_CLAUSE', 'tablespace ctx_objects compress 2');
	ctx_ddl.set_attribute('MY_STORAGE', 'P_TABLE_CLAUSE', 'tablespace ctx_objects');
	ctx_ddl.set_attribute('MY_STORAGE', 'S_TABLE_CLAUSE', 'tablespace ctx_objects');
END;
/

Open in new window

0
 
dba1234Author Commented:
INDEXTYPE IS CTXSYS.CONTEXT  Can you please explain little bit more.
0
 
slightwv (䄆 Netminder) Commented:
>>INDEXTYPE IS CTXSYS.CONTEXT

That is an Oracle Text index.  It allows fast text searching using the CONTAINS SQL function.

The docs are the place to start:
Oracle® Text Reference
http://docs.oracle.com/cd/E11882_01/text.112/e24436/toc.htm

and
Oracle® Text Application Developer's Guide
http://docs.oracle.com/cd/E11882_01/text.112/e24435/toc.htm
0
 
slightwv (䄆 Netminder) Commented:
What part of your question did I not answer?

I'm curious why you gave me a 'B' penalty.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now