Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: context index

Re: context index

From: David Boyd <davidb158_at_hotmail.com>
Date: Wed, 25 Apr 2007 14:52:43 -0400
Message-ID: <BAY101-F3166A655298995770E5640EF490@phx.gbl>


No. I logged in as myself and my default tablespace is users. I also tried running the creation statement as the owner whose default tablespace is medata. The default tablespace for CTXSYS is DRSYS. Both the index owner and I have DBA role granted.

>From: "Norman Dunbar" <norman.dunbar_at_environment-agency.gov.uk>
>Reply-To: norman.dunbar_at_environment-agency.gov.uk
>To: <oracle-l_at_freelists.org>, <davidb158_at_hotmail.com>
>Subject: Re: context index
>Date: Wed, 25 Apr 2007 15:15:30 +0100
>
>
>Dave,
>
> >> CREATE INDEX me.attachment_IDX ON me.test_table(ATTACHMENT)
> >> INDEXTYPE IS CTXSYS.CONTEXT
>
>were you running as SYSTEM by any chance?
>
>I have just create a context index on one of my test tables and it
>happily went into my default tablespace, well the various SYS_ILxxxxxx
>indexes did, the main index itself has no tablespace. I created the
>index while logged in as my own user BTW, not as another one.
>
>Also, if something of the index is created under CTXSYS what is the
>default tablespace for that schema too.



Donít quit your job Ė Take Classes Online and Earn your Degree in 1 year. Start Today!
http://www.classesusa.com/clickcount.cfm?id=866146&goto=http%3A%2F%2Fwww.classesusa.com%2Ffeaturedschools%2Fonlinedegreesmp%2Fform-dyn1.html%3Fsplovr%3D866144
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 25 2007 - 13:52:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US