context index

  • From: "David Boyd" <davidb158@xxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 25 Apr 2007 09:12:53 -0400

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

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


Other related posts: