On 11/10/2006 07:37:54 AM, Bobak, Mark wrote:
> Chalk that up to "learn something new every day"!
> I never knew you could create an index 'unusable'!
> Thanks Connor!
SQL> create table emp1 as select * from emp;
SQL> create unique index emp1_pk on emp1(empno) unusable;
SQL> select /*+ index(emp1,emp1_pk) */ max(empno) from emp1;
select /*+ index(emp1,emp1_pk) */ max(empno) from emp1
ERROR at line 1:ORA-01502
: index 'SCOTT.EMP1_PK' or partition of such index is in unusable
Index, apparently, can be created as "unusable" but, unfortunately, it cannot be used.