| Max. lenght exceeded error [message #62328] |
Wed, 14 July 2004 20:18  |
Tandle
Messages: 3
Registered: July 2004
|
Junior Member |
|
|
when i add unique constraint i am getting maximum length exceeded error.
my DB block size=8k
SQL> ALTER TABLE MODI_ARU ADD CONSTRAINT MODI_ARU_U1 UNIQUE (OWNER_COMP_ID,PARAM_NAME);
ALTER TABLE MODI_ARUADD CONSTRAINT MODI_ARU_U1 UNIQUE (OWNER_COMP_ID,PARAM_NAME)
*
ERROR at line 1:
ORA-01450: maximum key length (3218) exceeded
|
|
|
|
| Re: Max. lenght exceeded error [message #62329 is a reply to message #62328] |
Wed, 14 July 2004 23:34  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
Perhaps, this'll help:ORA-01450 maximum key length (string) exceeded
*Cause: The combined length of all the columns specified in a CREATE
INDEX statement exceeded the maximum index length. The maximum index
length varies by operating system. The total index length is computed
as the sum of the width of all indexed columns plus the number of
indexed columns. Date fields have a length of 7, character fields
have their defined length, and numeric fields have a length of 22.
Numeric length = (precision/2) + 1. If negative, add +1.
*Action: Select columns to be indexed so the total index length does
not exceed the maximum index length for the operating system. See
also your operating system-specific Oracle documentation. |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
