Oracle Error ORA-39789: “string”.”string” is not a valid type for column string.

Oracle Error Message

ORA-39789: “string”.”string” is not a valid type for column string.

Reason for the Error

Subtype specified was not a valid type for the column being loaded.

Solution

Ensure all subtypes specified are valid types for the column being loaded.