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
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.