CTXSYS.CONTEXT index in a specified tablespace AND partition question
398990Jul 14 2003 — edited Aug 31 2007I can't figure out how to create the following index in a specified tablespace.
CREATE INDEX ea_emails_ft02 ON ea_emails
(
body
)
INDEXTYPE IS CTXSYS.CONTEXT;
Also, this index is on a partitioned table. It seems that I can't partition the index, but I was wondering if there was some way to include the field that I partition the table on in the index (but not as a full-text field) so that Oracle does not have to get the full-text hits for all of the partitions and then pair it down to just the full-text hits from the partition that I actually want to search (I only ever use the index to find full-text hits from one partition at a time).