Re: context index

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@xxxxxxxxxxxxxxxxxxxxxxxxx>
Reply-To: norman.dunbar@xxxxxxxxxxxxxxxxxxxxxxxxx
To: <oracle-l@xxxxxxxxxxxxx>, <davidb158@xxxxxxxxxxx>
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

Other related posts: