This discussion is archived
0 Replies Latest reply: Dec 24, 2011 6:48 PM by 907368 RSS

CTX Text Index Question

907368 Newbie
Currently Being Moderated
I have been given a task to update a CTX Text Index that was created before I came onboard. The syntax for the current index is displayed below.

CREATE INDEX CTX_ITEM_NAME ON ITEM
(ITEM_NAME_TEXT)
INDEXTYPE IS CTXSYS.CONTEXT
PARAMETERS('storage item_name_storage filter ctxsys.null_filter memory 10M')
PARALLEL ( DEGREE 2 INSTANCES 1 )

It appears that when the index was created a preference "item_name_storage" was used. How can I found out what attributes were applied in this preference so that when I rebuild the index I keep the same storage settings?

I would appreciate any help anyone can provide so that I can get this issue resolved as soon as possible. Thanks in advance.

Jim

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points