Home » SQL & PL/SQL » SQL & PL/SQL » unusable index (merged)
unusable index (merged) [message #358411] Tue, 11 November 2008 02:56 Go to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
Hi,
I have table with 40 partition.I have create the global index in this table.After i have inserted 10000 data into this tables.I got the error index "unusable" state.After i rebuild the index and inserted large amount of data.Once agin i got the same error.frequently i got the same error.

My steps:
********
create table bank
(id number(9),
name varchar2(12),
account varchar2(12),
street varchar2(12));

I have create range partition based on the id column.

create index id_pk (id);

insert into bank
select *
from ext_bank;
commit;

delete from bank where id=1;

It shows a id_pk index is unusable.

how can resolve this issue?

Thanks,
Michael


Re: Index unusable state [message #358415 is a reply to message #358411] Tue, 11 November 2008 03:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Post what you actually did, that is copy and paste your SQL*Plus session.

Before read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and use code tags.
Use the "Preview Message" button to verify.

Regards
Michel
unusable index [message #358605 is a reply to message #358411] Tue, 11 November 2008 23:14 Go to previous messageGo to next message
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
Senior Member
why does index goes to unusable state?


Thanks,
Michael
Re: unusable index [message #358613 is a reply to message #358605] Tue, 11 November 2008 23:34 Go to previous message
rajavu1
Messages: 1574
Registered: May 2005
Location: Bangalore , India
Senior Member

Why?
and
Why?

Smile
Rajuvan.
Previous Topic: dumping data to text file(urgent)
Next Topic: Read a CSV file
Goto Forum:
  


Current Time: Fri Dec 02 20:58:40 CST 2016

Total time taken to generate the page: 0.07409 seconds