Home » SQL & PL/SQL » SQL & PL/SQL » unusable index on inserting data into partition table (Oracle 11.0.2)
unusable index on inserting data into partition table [message #654160] Thu, 28 July 2016 00:08 Go to next message
jbvenkat_mcq
Messages: 9
Registered: August 2010
Location: Pune
Junior Member
Hi,

I am getting error unusable index on inserting data into partition table. could you please assists how can over come from this error.

Regards,
Venkat
Re: unusable index on inserting data into partition table [message #654162 is a reply to message #654160] Thu, 28 July 2016 00:14 Go to previous messageGo to next message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
http://www.orafaq.com/wiki/Unusable_indexes
Re: unusable index on inserting data into partition table [message #654164 is a reply to message #654162] Thu, 28 July 2016 00:19 Go to previous messageGo to next message
jbvenkat_mcq
Messages: 9
Registered: August 2010
Location: Pune
Junior Member
because of unusable index error my job is getting failed. it's need to fix permanently
Re: unusable index on inserting data into partition table [message #654172 is a reply to message #654164] Thu, 28 July 2016 01:03 Go to previous message
Michel Cadot
Messages: 67946
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

You first need to know why it is unusable.
And you need to know if you need this index.

Previous Topic: XML tag selection
Next Topic: How to display report format data
Goto Forum:
  


Current Time: Sun Sep 19 06:03:48 CDT 2021