oracle-db-tools icon indicating copy to clipboard operation
oracle-db-tools copied to clipboard

ORA-00922: Missing or invalid option - generated table script

Open jwinkels opened this issue 1 year ago • 0 comments

When you generate a liquibase changeset for a table which ddl code has a create table and a following alter table statement, and you would like to update your target stage, the update command fails with a ORA-00922. When you check the sql-commands liquibase executed you can see that after the create table statement a semicolon is missing to sperate the alter table and the create table statement.

jwinkels avatar Apr 25 '24 09:04 jwinkels