DB: Oracle
Liquibase Community 4.18.0 by Liquibase
In our setup, LIQUIBASE.DATABASECHANGELOG is accessible to multiple accounts.
Changelogs are run in those accounts using these CLI parameters.
–liquibaseSchemaName=LIQUIBASE --url=$url
where
url=“jdbc:oracle:thin:$user/$pswd@(description=(address=(protocol=tcps)(host=$host)(port=$port))(connect_data=(service_name=$inst)))”
All accounts work ok except for one. All accounts are “supposed” to have the same permissions.
But for one account I get this
Unexpected error running Liquibase: ORA-00955: name is already used by an existing object
[Failed SQL: (955) CREATE TABLE LIQUIBASE.DATABASECHANGELOG (ID VARCHAR2(255) NOT NULL, AUTHOR VARCHAR2(255) NOT NULL, FILENAME VARCHAR2(255) NOT NULL, DATEEXECUTED TIMESTAMP NOT NULL, ORDEREXECUTED INTEGER NOT NULL, EXECTYPE VARCHAR2(10) NOT NULL, MD5SUM VARCHAR2(35), DESCRIPTION VARCHAR2(255), COMMENTS VARCHAR2(255), TAG VARCHAR2(255), LIQUIBASE VARCHAR2(20), CONTEXTS VARCHAR2(255), LABELS VARCHAR2(255), DEPLOYMENT_ID VARCHAR2(10))]
The table exists so why is it trying to create it?