Message-Id: <10479.104244@fatcity.com> From: "Walter K." Date: Wed, 26 Apr 2000 19:45:10 -0500 Subject: ORA-01450 maximum key length exceeded This is a multi-part message in MIME format. ------=_NextPart_000_4E9E_01BFAFB7.EEF19930 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 ------=_NextPart_000_4E9E_01BFAFB7.EEF19930 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

I just installed Personal 8i (Win98) on = one of my=20 PCs. I generated an Indexfile from an export and pre-created some tables = and=20 their indexes. Three of the index creation steps failed due to an = ORA-01450=20 error. According to the docs, a limit on the length of the index exists = which is=20 OS dependent. One of the indexes that failed was trying to create a=20 concatenation of three columns with the following data=20 types: number, varchar2(2000) and char(1). I'm guessing it = doesn't=20 like the second column in the mix.

My question is, where can I find out = what the=20 maximum key length for my system is? Does anyone know how the length is=20 computed?

Thanks!!

-w

------=_NextPart_000_4E9E_01BFAFB7.EEF19930-- __________________________________________________ Do You Yahoo!? Talk to your friends online with Yahoo! Messenger.