OraFAQ Forum: SQL & PL/SQL » unusable index on inserting data into partition table

Home » SQL & PL/SQL » SQL & PL/SQL » unusable index on inserting data into partition table (Oracle 11.0.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

unusable index on inserting data into partition table [message #654160]

Thu, 28 July 2016 00:08

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

Report message to a moderator

Re: unusable index on inserting data into partition table [message #654162 is a reply to message #654160]

Thu, 28 July 2016 00:14

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

http://www.orafaq.com/wiki/Unusable_indexes

Report message to a moderator

Re: unusable index on inserting data into partition table [message #654164 is a reply to message #654162]

Thu, 28 July 2016 00:19

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

Report message to a moderator

Re: unusable index on inserting data into partition table [message #654172 is a reply to message #654164]

Thu, 28 July 2016 01:03

Michel Cadot
Messages: 68653
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.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 13:57:47 CDT 2024