Maximum index length???? 
Author Message
 Maximum index length????
I want to create an index on a column which is of the type varchar(1000).

However, I receive an error message:
ORA-01450: maximum key length (758) exceeded.

So, I go to the Oracle doc to find out that I have exceeded the maximum
index length, which is platform specific.  I am using Oracle 8.0.5 on
Redhat Linux 6.0.  Anyway to solve the problem???

Thx.



Wed, 13 Feb 2002 03:00:00 GMT
 Maximum index length????


(if that email address didn't require changing)

Quote:
>I want to create an index on a column which is of the type varchar(1000).

>However, I receive an error message:
>ORA-01450: maximum key length (758) exceeded.

>So, I go to the Oracle doc to find out that I have exceeded the maximum
>index length, which is platform specific.  I am using Oracle 8.0.5 on
>Redhat Linux 6.0.  Anyway to solve the problem???

>Thx.

the maximum index length is a function of the blocksize.  you must have a 2k
blocksize.  On my 8k blocksize database it is:

*
ERROR at line 1:
ORA-01450: maximum key length (3218) exceeded

the max keylength is a bit less then half the blocksize.

The only way to increase your blocksize is to create a new database -- you
cannot modify the blocksize of an existing database.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st


Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation



Wed, 13 Feb 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Table name length (maximum identifier length)

2. maximum length of table and field names (SQL 6.5)

3. Maximum length of a row in SQL Server for CE

4. Maximum Table Name Length

5. Maximum length of dimension member properties question

6. Maximum Length of String For Dynamic Stored Procedures

7. instance name exceeds maximum length

8. Can maximum row length be changed?

9. maximum length of varchar

10. Question: is there a maximum record length?

11. Maximum length is incompatible wiht that of selected column in the cursor

12. Maximum length error


 
Powered by phpBB® Forum Software