alter index reg_id_pk enable

I want disable the index

Copy and paste your whole SQl*Plus session.

Index can not be disabled; drop it instead.

Thanks
Ved

SQL> create table t (val varchar2(10));

Table created.

SQL> create index i on t (upper(val));

Index created.

SQL> insert into t values ('michel');

1 row created.

SQL> commit;

Commit complete.

SQL> alter index i disable;

Index altered.

when there is function based index then only we can ble to disable the index

in other type of index we need to use unsable and after use we need to rebuild


Am I Right::::?


Regard
Lokesh

I already try that but getting errors

not getting proper way
thats why asking solution

how to use index for retrial of data::::::::::::?

I already try that but getting errors

SQL> CREATE TABLE c(c1 INT, c2 INT);

Table created.

SQL> CREATE INDEX ci ON c (c1, c2);

Index created.

SQL>  ALTER TABLE c ADD CONSTRAINT cpk PRIMARY KEY (c1) USING INDEX ci;

Table altered.

SQL> alter index ci disable;
alter index ci disable
*
ERROR at line 1:
ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option


SQL>  alter index ci unusable;

Index altered.

SQL>

after creation of Index

I want see or use index like

select * from emp

or

select index_name,ename from emp

like that

how we can use index to retrieve data::::?