My Oracle Support Banner

DDL Generation Add Invalid Line: "COLUMN COLUMN_NAME.ATTRIBUTE_NAME SUBSTITUTABLE AT ALL LEVELS" (Doc ID 2892770.1)

Last updated on SEPTEMBER 01, 2022

Applies to:

Oracle SQL Developer Data Modeler - Version 22.2 and later
Information in this document applies to any platform.

Symptoms

SQL Developer Data Modeler is adding an extra line that is causing the DDL to fail with "ORA-00922: missing or invalid option" when the column datatype is SDO_GEOMETRY.

The following line: COLUMN COLUMN_NAME.ATTRIBUTE_NAME SUBSTITUTABLE AT ALL LEVELS is causing this failure.

Changes

"Substitutable" field in the Physical Model was set to "Yes".

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.