Skip to Content.
Sympa Menu

grouper-users - Re: [grouper-users] Configuring Grouper 0.5 to use Oracle 8

Subject: Grouper Users - Open Discussion List

List archive

Re: [grouper-users] Configuring Grouper 0.5 to use Oracle 8

Chronological Thread 
  • From: Mark McLaren <>
  • To:
  • Subject: Re: [grouper-users] Configuring Grouper 0.5 to use Oracle 8
  • Date: Tue, 28 Dec 2004 17:35:04 +0000
  • Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=beta;; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=GXWXiS50SPtlFNmGOjkN9rBa+n6Orwwjw7V2dCwR13vUfSIEmFDobueIA4+JoTbJe++euEoJtSnwt801Yp34AmYO3IAlj7n43MMKbqV9I120nB8+U0wr2ze9TxYqrov7TLbBPBuaterp3Bwd0aemxspPysw1+LRNpSCcGIQEbD0=

On Mon, 27 Dec 2004 09:32:18 -0800, blair christensen
> On 2004.12.21 11:20, Mark McLaren wrote:
> > The next problem I received was "ORA-01450: maximum key length (758)
> > exceeded" error. To a certain extent this is a database instance
> > specific db_block_size configuration issue. In our case (with a 2K
> > block size) it meant that I had to reduce the length of certain
> > combined constrained columns so that the sum of the lengths would not
> > exceed 758. Notably these combinations:
> >
> > groupKey, groupField, memberKey, via
> > memberKey, memberID, subjectID, subjectTypeID
> >
> > So I arbitrarily set these lengths for these columns to 100 instead of
> > the 255 that I had initially chosen.
> Ouch. Should I assume that anyone using a remotely default Oracle
> configuration will run into this problem?

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.

> What version of Oracle are you using? And could I get the database
> schema file you used? And now it looks like I need to get myself an
> Oracle database to start testing against.

I'll get back to you with these details in due course.



Archive powered by MHonArc 2.6.16.

Top of Page