Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: "create index offline"

Re: "create index offline"

From: Mladen Gogala <mgogala_at_verizon.net>
Date: Fri, 10 Nov 2006 07:48:47 -0500
Message-id: <1163162927l.2875l.0l@medo.noip.com>

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;

Table created.

SQL> create unique index emp1_pk on emp1(empno) unusable;

Index created.

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 state

Index, apparently, can be created as "unusable" but, unfortunately, it cannot be used.

-- 
Mladen Gogala
http://www.mladen-gogala.com

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Nov 10 2006 - 06:48:47 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US