Grouper Users - Open Discussion List

[Gary Chapman <>]

With Oracle 9 (and presumably above), db_block_size can be set on a per
tablespace basis, at tablespace creation time.


blair christensen wrote:
> On 2004.12.28 17:35, Mark McLaren wrote:
>
> > Unfortunately yes.  In Oracle the unique combination of columns that
> > need to be indexed must fit inside a single db_block for efficient
> > indexing.  The db_block_size cannot AFAIK be changed with an existing
> > database instance.
>
>
> Well, this will make things more interesting.
>
>
> > I'll get back to you with these details in due course.
>
>
> Thanks.
>
> Come early January I should have an Oracle instance to experiment with myself.