Working around max key length

View All Public Scripts Login to Run Script

Statement 1

create or replace function f(a varchar2) return varchar2 
is 
begin 
return a; 
end;

Function created.

Statement 2

create table b (c varchar2(2 char))

Table created.

Statement 3

create index b_i on b (f(c)) online

ORA-30553: The function is not deterministic

Statement 4

create index b_i2 on b (substr(f(c),1,3)) online

ORA-30553: The function is not deterministic

Statement 5

create or replace function f(a varchar2) return varchar2 deterministic 
is 
begin 
return a; 
end;

Function created.

Statement 6

create table b (c varchar2(2 char))

ORA-00955: name is already used by an existing object

Statement 7

create index b_i on b (f(c)) online

ORA-01450: maximum key length (6398) exceeded

Statement 8

create index b_i2 on b (substr(f(c),1,3)) online

Index created.

Additional Information