SQLcl 24.2: Schema Names Are Missing in SQL Files When Using "liquibase Generate-schema"
(Doc ID 3049884.1)
Last updated on NOVEMBER 16, 2024
Applies to:
Oracle SQLcl - Version 24.0 to 24.2 [Release 24]Information in this document applies to any platform.
Symptoms
On : SQLcl 24.2 version, Liquibase
ACTUAL BEHAVIOR
When using older versions of SQLcl (such as 23.3) and "liquibase generate-schema -sql", the table schema names are included in the generated .sql files.
However, as of SQLcl 24, the table schema names are missing in the generated .sql files when using "liquibase generate-schema -sql".
For other commands, the "-output-default-schema" option is available, but this option is not available for the "generate-schema" command.
Documentation reference here.
This is only relevant for the SQL files generated using the "-sql" option -- the .XML files are not relevant and do include the schema name.
EXPECTED BEHAVIOR
Want schema name to show up in generated .sql files when using "liquibase generate-schema -sql".
STEPS
The issue can be reproduced at will with the following steps:
The former includes the schema name in the .SQL file output, but the latter does not.
Changes
Upgraded to SQLcl 24.2.
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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |