RE: Specifying default tablespaces for indexes

Hi Mladen,

I was there at that time in Maastricht too. In fact, I am born in Maastricht, although on a ship that happened to be in that old town in Limburg in Hollannd. For me it's my hometown..

I had my fights with Ken Jacobs also when I was still working for = Oracle. I
remember when Oracle 8 beta was being launched internally in Oracle and = that
I ran into a bug, for which I tried out a workaround but then ran into another bug for which I tried out a workaround but then ran into another = bug
for which I tried out a workaround but then ran into another bug. Then frustrated to the limit I sent out an email to the internal rdbms mailinglist complaining that 'we should test more on 8 before launching = it'
or something similar. Ken's reply was a kick in my ass because I should = not
have been so negative.=20
Unfortunately I lost this email.

Regards,
Andre v Winssen
De Meern

-----Oorspronkelijk bericht-----
Van: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]
Namens Mladen Gogala
Verzonden: woensdag 15 juni 2005 17:11
Aan: jdunn_at_sefas.com
CC: Oracle-L_at_freelists.org
Onderwerp: 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
> =20
>

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

--=20
Mladen Gogala
Oracle DBA
Ext. 121

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

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