Demo: Using SQLcl and Liquibase to version your Oracle Database

I'll show you in 5 minutes you can use the friendly SQLcl command line interface to generate a Liquibase changeset for your Oracle Schema, how to update a new schema with that changeset, and finally how you can use the sqlFile feature to do things like INSERT data to your tables.

Oracle SQLcl is a modern, friendly command line interface for Oracle Database. In the Summer of 2019, we introduced support for Liquibase - and also enhanced its Oracle support. We generate the changelogs for you, figure out the right order to apply those changes, and even automatically handle rollback for you.

[mohamedheba]

Hi Jeff,
I am using lb generate-schema -split to extract all changes related to a schema in a source oracle DB. and before running this command I set DDL off for STORAGE, PARTITIONING, SEGMENT_ATTRIBUTES, TABLESPACE, EMIT_SCHEMA and SIZE_BYTE_KEYWORD.
after export finished i find that indexes xml file contains all information related storage and all other INDEX_ATTRIBUTES.
the problem is when i try to update destination schema "In a different DB" i receive error "ORA-02203: INITIAL storage options not allowed".
I notices when I use command LB GEO -OBN INDEX_NAME -OBT INDEX, xml generate without storage attributes and the update complete successfully.
is there any option to avoid storage and index attribute in generate schema command?

[rdi]

Hello Jeff, what is your opinion about using sqlcl in a production environment and using it with cron jobs through crontab to execute shell scripts that currently run sqlplus scripts? Is sqlcl a tool that could be used reliably in that way? Some of the format features could come in handy for those type of jobs.

[AlexLimaN]

Hi Jeff, I do a lot of migrations and upgrades where we need to create the schema ahead of the data migration, would you use this process to do that or something different? Currently i have a exp/imp and other scripts process, but if there is something more efficient this days i would be happy to try.