Error Message :
U0003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR', ",'ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION'.
Issues with installing ILM in an Oracle database
Root Cause: If you created your AE schema with version 9 SP6 or lower you will run in this issue.
The reason is that Oracle company changed the default value for number column's between oracle releases 9i/10g/11/12.
Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
This field was added on 30/03/2017. This article has not been updated yet. Refer to the "Description" or "Workaround" sections for solution information.
You could get the DBA to do a full export and then create the schema new and then import.