<div>
You may query<br>- DBA_PART_INDEXES<br>- ALL_PART_INDEXES<br>- USER_PART_INDEXES<br>for information about the partitioned indexes (and its names)...<br><br>Then, you could try:<br><pre><code class="code-1 nolinks" id="code-20-43339383-1"><span>alter index index_name rebuild partition partition_name;</span>
</code></pre><br><a href="http://www.dba-oracle.com/t_ora_01502_index_string_string_or_partition_of_such_index_is_in_usable_state.htm" rel="ugc">http://www.dba-oracle.com/t_ora_01502_index_string_string_or_partition_of_such_index_is_in_usable_state.htm</a>
</div>


Software Intern

Steve Sperber

<div>
What query to write to get the partition name of this index?<br>Why it happened? How&nbsp;<br><br><br>
</div>


<div>
<pre><code class="code-1 nolinks" id="code-20-43339500-1"><span>select *</span>
<span>&nbsp; from user_part_indexes a</span>
<span>&nbsp;where a.table_name = '&lt;here goes the table name&gt;';</span>
</code></pre>
</div>


<div>
About the reason(s) why this might happen:<br><a href="https://docs.oracle.com/database/121/SUTIL/GUID-C44AADF7-777D-4847-A5ED-75E36B40D0EB.htm#SUTIL1305" rel="ugc">https://docs.oracle.com/database/121/SUTIL/GUID-C44AADF7-777D-4847-A5ED-75E36B40D0EB.htm#SUTIL1305</a><br><br><a href="https://asktom.oracle.com/pls/apex/f?p=100:11:0::::p11_question_id:1859798300346695894" rel="ugc">https://asktom.oracle.com/pls/apex/f?p=100:11:0::::p11_question_id:1859798300346695894</a>
</div>


<div>
<div class="content wysiwyg-content fr-view">
<p>I get below Error inserting data in the table with 1 primary key and 3 foreign keys:</p><pre><code class="code-1 nolinks" id="code-10-29224527-1"><span>ORA-01502: Index '&lt;schema.table_names_primary_key&gt;' or partition of such index is in unusable state.</span>
</code></pre><p><br></p><p>1st row below is the Primary key index &amp; I do not know the Partition.</p><p><a href="https://filedb.experts-exchange.com/incoming/2021/09_w38/1572883/INDEX_NAME.PNG" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2021/09_w38/1572883/INDEX_NAME.PNG" class="fr-fic fr-dib"></a></p><p><br></p><p>Why is this happening &amp; How to fix this issue?</p><p><br></p><p><br></p>
</div>
</div>


INDEX_NAME.PNG


I get below Error inserting data in the table with 1 primary key and 3 foreign keys:
ORA-01502: Index '<schema.table_names_primary_key>' or partition of such index is in unusable state.
1st row below is the Primary key index & I do not know the Partition.
Why is this happening & How to fix this issue?

ORA-01502: Index or partition of such index is in unusable state.

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.