Config DB error during Alter column, modifying Maximo Attribute
Config DB can sometimes fail while altering columns if the attributes names are oracle keywords. Usually its a good idea to make sure attribute names and objects in Maximo are not same as one of oracle keywords. Recently we faced an error while using a scope as an attribute name. We were trying to modify size. Error starting at line 34 in command: ALTER TABLE INSPECTPROCESS MODIFY SCOPE VARCHAR2 (100) Error report: SQL Error: ORA-00904: : invalid identifier 00904. 00000 - "%s: invalid identifier" *Cause: *Action: As SCOPE is an oracle keyword with special meaning, the alter statement was failing. To fix it we had to run the below statement manually instead. Note the extra set of brackets. ALTER TABLE INSPECTPROCESS MODIFY ( SCOPE VARCHAR2(100BYTE) ) ;