Hi Friends,

When I am trying to insert a record, I get error like this,

insert into test values (10);
insert into test values (10)
*
ERROR at line 1:
ORA-01502: index 'SCOTT.PK_TEST' or partition of such index is in unusable
state

How to solve this.

TIA,
Venkat



"THIS E-MAIL MESSAGE ALONG WITH ANY ATTACHMENTS IS INTENDED ONLY FOR THE
ADDRESSEE and may contain confidential and privileged information.
If the reader of this message is not the intended recipient,
you are notified that any dissemination, distribution or copy of this
communication is strictly Prohibited.
If you have received this message by error, please notify us
immediately, return the original mail to the sender and delete the
message from your system."

Oracle LazyDBA home page