?
Solved

oracle error: 1502. partition of such an index is in unusable state.

Posted on 2010-01-13
5
Medium Priority
?
1,990 Views
Last Modified: 2013-12-18
Hi,

just created a new schema and am receiving this error whenever trying
to insert data:
index 'indexname' or partition of such index is in unusable state.

Do I need to rebuild the indexes? Do I need to recreate the schema?

Thanks
0
Comment
Question by:Sainai
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 30

Expert Comment

by:Reza Rad
ID: 26302469
DROP the specified index, or REBUILD the specified index, or REBUILD the unusable index partition
0
 
LVL 14

Accepted Solution

by:
shru_0409 earned 400 total points
ID: 26302471
DROP the specified index, or REBUILD the specified index, or REBUILD the unusable index partition

for more information check this link
http://www.experts-exchange.com/Database/Oracle/Q_24568621.html

try it..
0
 
LVL 15

Assisted Solution

by:Shaju Kumbalath
Shaju Kumbalath earned 600 total points
ID: 26302696
only thing u need to do is to rebuild the indexs,
for getting the dynamic script use

select 'alter index '||OWNER||'.'||index_name||' rebuild' from dba_indexes where owner='YOUR_SCHEMA' ;
0
 
LVL 15

Assisted Solution

by:Shaju Kumbalath
Shaju Kumbalath earned 600 total points
ID: 26302707
OR rebuild only invalid indexes

select 'alter index '||OWNER||'.'||index_name||' rebuild' from dba_indexes where owner='YOUR_SCHEMA' AND
STATUS='INVALID'
0
 
LVL 30

Expert Comment

by:Reza Rad
ID: 26303017
@sainai
What was the different between first post that i suggest to you and second post which you select as solution ??????????!!!!!!!!!!!

0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: You must have administrative privileges in order to configure lead or case queues. Salesforce.com (http://www.Salesforce.com) is a cloud-based customer relationship management (CRM) system. It is widely used around the world by sales and ma…
Salesforce.com is a cloud-based customer relationship management (CRM) system. In this article, you will learn how to add and map custom lead and contact fields to your Salesforce instance.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question