Skip to Main Content

SQLcl: MCP Server & SQL Prompt

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Project deploy and liquibase-schema-name

Oleh Tyshchenko5 days ago

I am using SQLcl 25.2 and connecting to an Oracle 19c database.

What is my options if I want to change the schema SQLcl use for the creation of Liquibase objects (e.g., DATABASECHANGELOG etc) with liquibase-schema-name parameter?

My scenario is as follows: I have a project consisting of two schemas - the main one and the audit one. To handle all objects I do project export/stage/deploy using a privileged user. But this means that during deploy all Liquibase objects are created within the schema of this privileged user. I don't want this, I would prefer to have these objects in my main schema.

Comments
Post Details
Added 5 days ago
0 comments
30 views