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
