Re: Specifying default tablespaces for indexes

John Dunn wrote:

>When I create a user is it possible to specify a default tablespace for
>indexes that is different from the default tablespace for tables?. Or can I
>only specify a different tablespace for  indexes when I create the index?
>
>This is Oracle 9.2
>  
>
The request for so called "default index tablespace" has been out there 
since the late Jurassic/ early Cretassic
 (version 7.0.16) but  Oracle doesn't want to accommodate it. It looks 
like they don't want to have database
which is too easy to handle so that DBA staff wouldn't get spoiled. I 
believe that the only way to get Oracle to
do it is to pressure IBM to put something like that as a UDB feature. 
That would motivate Oracle Corp. to do
something about "default index tablespaces". Obviously, questions and 
requests from the despised creatures like
Oracle RDBMS users (known as "suckers" within the Oracle Corp) are not 
nearly enough. I personally asked
Ken Jacobs for that on EOUG which was held on 1995 (I'm not sure about 
the year) in Maastricht, NL. Few
months after (June, 2005) its still not there. May be, it will work in 
July 3005. No guarantees for anything earlier
then that.

-- 
Mladen Gogala
Oracle DBA
Ext. 121


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

Other related posts: