Oracle Error ORA-30737: cannot create subtable of a type which is not a subtype of the type of the supertable

Oracle Error Message

ORA-30737: cannot create subtable of a type which is not a subtype of the type of the supertable

Reason for the Error

An attempt was made to create a subtable(subview) of a type which is not a subtype of the type of the super object.

Solution

Change the type of the subtable to be a subtype of the superobject’s type and then retry the operation.