My Oracle Support Banner

Some Indexes Or Index [sub]partitions Of Table PJI.PJI_PA_PROJ_EVENTS_LOG Have Been Marked Unusable (Doc ID 2484933.1)

Last updated on OCTOBER 28, 2022

Applies to:

Oracle Project Costing - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6 version, System Tuning Issue

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


ERROR
-----------------------
Tue Nov 20 01:06:16 2018
TABLE SYS.WRP$_REPORTS: ADDED INTERVAL PARTITION SYS_P27168 (3246) VALUES LESS THAN (TO_DATE(' 2018-11-21 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
TABLE SYS.WRP$_REPORTS_DETAILS: ADDED INTERVAL PARTITION SYS_P27169 (3246) VALUES LESS THAN (TO_DATE(' 2018-11-21 01:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
Tue Nov 20 01:06:56 2018
Some indexes or index [sub]partitions of table PJI.PJI_FM_EXTR_PLNVER4 have been marked unusable
Tue Nov 20 01:17:04 2018
Tue Nov 20 03:17:55 2018
Some indexes or index [sub]partitions of table PJI.PJI_FM_EXTR_PLNVER4 have been marked unusable
Tue Nov 20 03:17:55 2018
Some indexes or index [sub]partitions of table PJI.PJI_PA_PROJ_EVENTS_LOG have been marked unusable

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.