ORA-01450 maximum key length exceeded

From: Walter K. <alden14004_at_yahoo.com>
Date: Wed, 26 Apr 2000 19:45:10 -0500
Message-Id: <10479.104244@fatcity.com>

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>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.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>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?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks!!</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>-w</FONT></DIV></BODY></HTML>

------=_NextPart_000_4E9E_01BFAFB7.EEF19930--

Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger. Received on Wed Apr 26 2000 - 19:45:10 CDT