Re: Granting table privileges

From: Howard J. Rogers <howardjr20002_at_yahoo.com.au>
Date: Wed, 9 Apr 2003 13:51:34 +1000
Message-ID: <OCMka.10144$1s1.168134@newsfeeds.bigpond.com>

"Peter" <no_email_at_no_email.com> wrote in message news:b701am$bhc$1_at_bunyip.cc.uq.edu.au...
> Cool, I was wondering when they would bring this feature in. Thanks for
the
> info! I just hope that it's not a violation of Oracle's security model :)
>
> Now we just need to be able to make a default index tablespace for the
> users.
>

With a certain sinking feeling, can I ask why?

There is no need for indexes intrinsically to be housed in their own tablespace, but rather you should seek to eliminate I/O hot-spots and sources of I/O contention, which can arise as much from an index-index or table-table bun-fight as from an index-table one. Therefore, such a default index tablespace would be pointless, erroneous and deeply misleading.

I'm glad we haven't got to that stage yet.

Regards
HJR Received on Tue Apr 08 2003 - 22:51:34 CDT