oracle-db-tools
oracle-db-tools copied to clipboard
ORA-00922: Missing or invalid option - generated table script
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.