Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Indexes have been marked unusable?

Beauty_and_dBestAug 19 2018 — edited Aug 19 2018

12c

OL6

Hi ALL,

We found this warning in out alert logs.

Fri Aug 17 09:30:27 2018

Some indexes or index [sub]partitions of table PJI.PJI_FM_EXTR_PLNVER4 have been marked unusable

Fri Aug 17 09:34:26 2018

Completed checkpoint up to RBA [0x3a.2.10], SCN: 5965194996377

Fri Aug 17 09:36:01 2018

Some indexes or index [sub]partitions of table PJI.PJI_FM_EXTR_PLNVER4 have been marked unusable

And invalid view in PA: APPS PA_STATUS_RSRC_GENERIC_V VIEW

Please help....

Kind regards,

This post has been answered by AndrewSayer on Aug 19 2018

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 16 2018

Added on Aug 19 2018

#general-database-discussions

9 comments

889 views