I am creating a table and I get this error.
This is exclusively happening in one NT machine..
I am able to create the same table on another NT machine and a sun solaris machine..
one of the fileds is unique and has a length of 2k..
on the same machine that had a problem if i reduce the size say varchar2(20), it works.......
what can be done..
FILE_KEY VARCHAR2(2048) CONSTRAINT UNQ_FILE UNIQUE ,
CREATE TABLE FILE_DATASOURCE
*
ERROR at line 1:
ORA-01450: maximum key length (758) exceeded
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.