Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01502: index in unstable state (oracle 10g)
ORA-01502: index in unstable state [message #325379] Fri, 06 June 2008 01:16 Go to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
I need one clarification
1.whether can we insert a values in a particular table when the index is in unstable state
2.then how is possible to make an index to statble state

Thanks,
Re: ORA-01502: index in unstable state [message #325390 is a reply to message #325379] Fri, 06 June 2008 02:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-01502: index '%s.%s' or partition of such index is in unusable state
 MERGE: 1489 RENUMBERED TO 1502
 *Cause: An attempt has been made to access an index or index partition
         that has been marked unusable by a direct load or by a DDL
         operation
 *Action: DROP the specified index, or REBUILD the specified index, or
         REBUILD the unusable index partition

Regards
Michel
Re: ORA-01502: index in unstable state [message #325455 is a reply to message #325390] Fri, 06 June 2008 04:37 Go to previous messageGo to next message
ram anand
Messages: 244
Registered: February 2008
Location: india
Senior Member
Hi,
I tried to rebuild the Partition index ,but it shows the following error ,can u pls help on this issue

alter index XPKDATED_ITIN rebuild partition PARTITION_06;


ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found


Thanks,
Re: ORA-01502: index in unstable state [message #325458 is a reply to message #325455] Fri, 06 June 2008 04:39 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
So either change the index to non-unique, or delete/modify the duplicate rows.
Previous Topic: Connect by clause
Next Topic: Test-data insert execution time
Goto Forum:
  


Current Time: Sun Dec 04 08:57:25 CST 2016

Total time taken to generate the page: 0.15584 seconds