Re: Ora-1450 not in Oracle 10.2

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: Mon, 2 Jun 2008 19:04:55 -0700 (PDT)
Message-ID: <9c37a59e-63fb-40a8-8e16-4fac19f6ef5b@c65g2000hsa.googlegroups.com>

On Jun 2, 1:31 pm, "Terry Dykstra" <tddyks..._at_forestoil.ca> wrote:
> A 3d party application is trying to generate a weird index and I get an
> ORA-01450 error (Oracle 9.2.0.7 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:04:55 CDT