I created a context index as following: CREATE INDEX me.attachment_IDX ON me.test_table (ATTACHMENT) INDEXTYPE IS CTXSYS.CONTEXTThe index is stored in SYSTEM tablespace. I was wondering if there is a way that I can create a context index in the tablespace I want. The context index in SYSTEM tablespace causes a VIOLATION for copying data with transportable tablespace method.
Dave _________________________________________________________________Mortgage refinance is Hot. *Terms. Get a 5.375%* fix rate. Check savings https://www2.nextag.com/goto.jsp?product=100000035&url=%2fst.jsp&tm=y&search=mortgage_text_links_88_h2bbb&disc=y&vers=925&s=4056&p=5117
-- //www.freelists.org/webpage/oracle-l