Welcome Guest ( Log In | Register )



Performance Tuning Reference poster
Oracle training in Linux 

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.
post Jul 25 2017, 02:01 AM
Post #1


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

Hi Burleson,

We are currently in Oracle Database 12c Enterprise Edition Release - 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.

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' );

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
post Jul 25 2017, 05:14 AM
Post #2

Advanced Member

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

Hi Sumak,

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


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: 20th October 2017 - 04:23 PM