My Oracle Support Banner

Lb Genschema Fails With ORA-00001: Unique Constraint <schema>DATABASECHANGELOG_EXPORT_PK Violated (Doc ID 2879794.1)

Last updated on JULY 05, 2022

Applies to:

Oracle SQLcl - Version 22.1 to 22.1 [Release 22]
Information in this document applies to any platform.

Symptoms

While running this command in SQLcl 22.1:

SQL>  lb genschema -split -grants


The following error shows up:

[Method sortCaptureTable]: ORA-00001: unique constraint (<SCHEMA>.DATABASECHANGELOG_EXPORT_PK) violated
ORA-06512: at "<SCHEMA>.SQLCL_LB_CAPTURE", line 205


ORA-00001: unique constraint (XXIS.DATABASECHANGELOG_EXPORT_PK) violated
ORA-06512: at "<SCHEMA>.SQLCL_LB_CAPTURE", line 205

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

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