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
-- //www.freelists.org/webpage/oracle-l