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
Received on Wed Jun 15 2005 - 11:13:40 CDT
