How? create a text index in specific tablespace
619379Apr 2 2008 — edited Apr 29 2008I want to create a text index on my clob column.
example:
CREATE INDEX my_docs_doc_idx ON my_docs(doc) INDEXTYPE IS CTXSYS.CONTEXT;
how do specify a tablespace like I do in a normal column index?
example:
CREATE INDEX cust_dup_idx
ON customer(sex, hair_color, customer_id)
PARALLEL 35
NOLOGGING
COMPRESS 2
TABLESPACE 32k_ts;