Hi all
We have Oracle 11g Std Edition on windows 64 Bit 2012 Serve. We are unable to create conditional index using where clause as under
create table abc(id int primary key,complete_flag varchar2(1),type varchar2(10),status varchar2(10));
create index abc_indx1 on abc(type, status) where complete_flag = 'N';
At index creation we get the error ORA-02158 Invalid Create Index Option
Kindly advise, where I am doing mistake
Regards
Suresh Bansal