Re: Ora-1450 not in Oracle 10.2

From: Charles Hooper <>
Date: Mon, 2 Jun 2008 19:06:44 -0700 (PDT)
Message-ID: <>

On Jun 2, 1:31 pm, "Terry Dykstra" <> wrote:
> A 3d party application is trying to generate a weird index and I get an
> ORA-01450 error (Oracle SE on W3K). But looking in the 10.2
> documentation that error is not even listed. Did Oracle remove the
> restriction for the maximum length of an index? I couldn't find anything in
> the 10.1/2 manuals about this.
> --
> Terry Dykstra

It might be worthwhile to check Metalink:

Note: 136158.1 ORA-01450 and Maximum Key Length - How it is Calculated
Note:236329.1 ALTER INDEX REBUILD ONLINE Fails with ORA-01450
Note:579372.1 Getting ORA-1450 Error When Trying To Create an Index
Against a Table
Note:454144.1 Create_Sem_Network Fails With Error ORA-13199 and Sqlerrm=ORA-01450

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Mon Jun 02 2008 - 21:06:44 CDT

Original text of this message