Pre-Check - Invalid Objects found in Database, but command doesn't compile

book

Article ID: 197083

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

After running the installation "Pre-Check"  I received a warning message for "check-db-invalid-objects.xml". To correct the problem I ran the following statement -

"ALTER TYPE BODY CRV_RAW_SEGMENT COMPILE;"

It failed with error:

SQL Error: ORA-00922: missing or invalid option

 

Environment

Release : 15.8

Component : CA PPM APPLICATION

Resolution

Used this command instead which worked:

ALTER TYPE CRV_RAW_SEGMENT COMPILE;