Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> Oracle TEXT Indexes, How to create a TEXT index with a table space specified.
sumak
post Jul 25 2017, 02:01 AM
Post #1


Newbie
*

Group: Members
Posts: 7
Joined: 22-June 17
Member No.: 52,035



Hi Burleson,

We are currently in Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit.

We have a requirement for implementing context text search, however it is suggested to create the index in a separate table space.

Can you help with the steps involved for creating the index.

Below are the steps we followed. But unable to understand how to specify the table space.

BEGIN
ctx_ddl.drop_preference ( 'TEXT_SEARCH_STORAGE' );
ctx_ddl.create_preference( 'TEXT_SEARCH_STORAGE', 'BASIC_STORAGE' );
ctx_ddl.set_attribute ( 'TEXT_SEARCH_STORAGE', 'STAGE_ITAB', 'true' );
END;


CREATE INDEX my_index ON my_table ( name )
indextype IS ctxsys.context parameters( ' storage TEXT_SEARCH_STORAGE sync (on commit)' );
Go to the top of the page
 
+Quote Post
burleson
post Jul 25 2017, 05:14 AM
Post #2


Advanced Member
***

Group: Members
Posts: 13,492
Joined: 26-January 04
Member No.: 13



Hi Sumak,

The "create index" syntax supports the specification of a tablespace name!

http://dba-oracle.com/googlesearchsite_pro....com%2F&ss=

Just remember, context indexes get stale very quickly.

Good luck!


--------------------
Hope this helps. . .

Donald K. Burleson
Oracle Press author
Author of Oracle Tuning: The Definitive Reference
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 22nd August 2017 - 02:21 AM