How are the generate-changelog changeset order determined

Hi Team,

The version of liquibase : 4.23.0

I have a question about the order in which the generate-changelog command creates the changesets. We have an existing Oracle database. When running generate-chnagelog and it creates the create table changesets above the create sequence change sets, which then causes the error ORA-02289: sequence does not exist when running update using the generated changelog on a new database. There is a table with a default seqx.nextval value.

Oracle feature for reference: ORACLE-BASE - DEFAULT Values for Table Columns : Enhancements in Oracle Database 12c Release 1 (12.1)

I am trying to recreate it on a small scale but the changelog generated has the sequences above the tables. What will cause this? I this a bug or a misconfigured database ?

1 Like