context index

From: David Boyd <davidb158_at_hotmail.com>
Date: Wed, 25 Apr 2007 09:12:53 -0400
Message-ID: <BAY101-F26401420B6A7501B4D9DE1EF490@phx.gbl>

I created a context index as following:

CREATE INDEX me.attachment_IDX ON me.test_table (ATTACHMENT)
INDEXTYPE IS CTXSYS.CONTEXT The 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

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Apr 25 2007 - 08:12:53 CDT