How to fix the Oracle error CRS-02803: Attribute ‘string’ has already been declared in a derived type ‘string’?

In this post, you’ll learn more about the Oracle ErrorCRS-02803: Attribute ‘string’ has already been declared in a derived type ‘string’ with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

CRS-02803: Attribute ‘string’ has already been declared in a derived type ‘string’

Reason for the Error CRS-02803: Attribute ‘string’ has already been declared in a derived type ‘string’

Cause: An attempt was made to add a new attribute definition to a resource type that has an identically named attribute already defined in one or more derived types. Attributes declared in base types can be overridden in derived ones, but the opposite is not allowed.

How to fix the Error CRS-02803: Attribute ‘string’ has already been declared in a derived type ‘string’ ?

You can fix this error in Oracle by following the below steps

Action: Pick a different attribute name or delete the derived type(s), resubmit, and then add derived types back.