| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-01450 maximum key length exceeded
Walter,
The key length is limited by the db block size as a key value can't span multiple blocks, so it's the varchar(2000) column that's the main problem. I suspect that your new db has a 2K block size, but the db from which it was exported was using a larger block size. Keep in mind that the key value must be smaller than the db block size for overhead.
Unfortunately the only way to create this index is to recreate the db with a larger blocksize as you can't decrease the column size unless the column is empty.
HTH,
>From: "Walter K." <alden14004_at_yahoo.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: ORA-01450 maximum key length exceeded
>Date: Wed, 26 Apr 2000 17:59:09 -0800
>
>I just installed Personal 8i (Win98) on one of my PCs. I generated an
>Indexfile from an export and pre-created some tables and their indexes.
>Three of the index creation steps failed due to an ORA-01450 error.
>According to the docs, a limit on the length of the index exists which is
>OS dependent. One of the indexes that failed was trying to create a
>concatenation of three columns with the following data types: number,
>varchar2(2000) and char(1). I'm guessing it doesn't like the second column
>in the mix.
>
>My question is, where can I find out what the maximum key length for my
>system is? Does anyone know how the length is computed?
>
>Thanks!!
>-w
 |
 |