Oracle Error ORA-22869: depth of type dependency hierarchy exceeds maximum limit

Oracle Error Message

ORA-22869: depth of type dependency hierarchy exceeds maximum limit

Reason for the Error

The type dependency hierarchy was structured to have depth greater than 1024.

Solution

Re-structure the type dependency hierarchy to a shorter depth.