Re: default index tablespace?

I think Howard and David are being a little harsh here. After all, taking David's argument to the logical conclusion why does Oracle have a default tablespace at all ?

Personally I think that a default tablespace for indexes would be a very convenient idea. I also think a default tablespace for sorting that is different from the default tablespace for global temporary tables and the default tablespace for hashing and the default tablespace for temporary LOBs would be a good idea. (And the default tablespace for indexes on global temporary tables --- )

I don't really see it as an issue if it takes 15 minutes to create a user: (a user is for life, not just for Christmas ;)

I agree with both of you that the right way for doing things in a properly controlled production system is to write precise and complete instructions. But there are times when you cannot be in total control, then every little lever helps.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Howard J. Rogers wrote in message <3a4bb0b9_at_news.iprimus.com.au>...


>

><wutang_warrior_at_my-deja.com> wrote in message

>news:92g0hm$mbn$1_at_nnrp1.deja.com...

>> So wouldn't it be a good idea to have the ability to assign a default

>> index tablespace to users?

>>

>

>Well, if we're talking good ideas, it would be a good idea if Oracle would

>install itself in *just* the right location without furthur hassle or

>intervention; it would be a good idea if it would read the mind of the

>users, instead of them having to type stuff in



David Fitzjarrell wrote in message <92g7sn$sqr$1_at_nnrp1.deja.com>...



>No.  Laziness has no place in database management, and that includes

>object creation.  If one were to have the ability to assign a 'default

>index tablespace' to a user that would require Oracle to know the

>difference between an index segment and a table segment which would be

>a far more complex issue than you realise.  Not having such a default

>requires the user to think about the objects he or she is creating and

>where best to place them, seeking guidance when necessary.