ORA-12899: value too large for column "XXX"."DATABASECHANGELOG_EXPORT"."DEP_NAME"

[ogroef]

When an object has a lot of dependencies, following ORA-12899 is being raised during "lb genschema"-command. To my opinion it is due the 'DEP-NAME'-column specificiation. It has a specification of VARCHAR2(200).

If I may propose to change this column to a XMLType. When storing these dependencies in an xmltype, this error will never raised. I propose XMLType instead of VARCHAR2, because VARCHAR2 has a limit of 4000 characters (used in a table definition).

See post in the community.

Kind Regards
Olivier

┆Issue is synchronized with this Jira Bug by Unito