When creating a new model from an existing SQL DDL script (i.e. Content: "from SQL" is selected), the import fails if the table has a foreign key constraint with no columns listed on the foreign table. In that situation it should use the primary key for the referenced table as the referenced columns. Instead I received a cryptic error of ERROR:No more content.
A sample DDL that demonstrates this behavior is:
CREATE TABLE person (
id NUMBER(6) NOT NULL,
first_name VARCHAR2(30) NOT NULL,
last_name VARCHAR2(30) NOT NULL,
changed_by NUMBER(6) NOT NULL,
PRIMARY KEY (id),
FOREIGN KEY (changed_by)
I would need to change the last line to say REFERENCES person (id) for this DDL to be accepted. This DDL was from a very old Oracle database and I selected 11c/12g as the version.
Kundesupport af UserEcho