Index problem : max lenght exceed
Posted on 2001-09-17
I'm working with Oracle 8.1, and I have a little problem.
I need to create an index (UNIQUE) on 10 columns. The problem is that 3 of this columns have are VARCHAR2 (255).
So each time I tried to create my table I have this error message : ORA-01450: maximum key length (758) exceeded.
I've tried to create the constrainte in Alter table instead in the create table... but it gives the same message.
And I cannot remove any field in the constraint... there's a way to do the job ?
ALTER TABLE InterventionPlans
ADD CONSTRAINT UniqueInterventionPlans
UNIQUE(AgencyId, ResponseTypeId, RecommendationId, Data1,
Data2, Data3, AlarmLevel, FromWeekDay, FromTime, ToWeekDay, ToTime)