Liquibase Generate Schema Command Pulls Different START WITH Value For A Table Using IDENTITY Column (Doc ID 3052938.1)

Last updated on NOVEMBER 19, 2024

Applies to:

Goal

A SQLcl step with a Liquibase Generate Schema command used to pull schema objects definition is setting the "START WITH" value to an undesired value.

After creating a table with IDENTITY column in a schema specifying START WITH 1, INCREMENT BY 1 and CACHE 20 with the following statement

This is resulting in deployment of many table objects to the target schema with different "START WITH" value.

Consequently, the developers have to review a large number of objects that have not changed from DDL perspective instead of just the ones that thay have actually modified.

How to get assistance on that?
 

Solution

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