oracle-liquibase.jar
file in liquibase/lib/ext
. liquibase
or lb
. To display a list of all available commands, execute liquibase
or lb
with no arguments. liquibase(lb) genobject <object_type> <object_name>
Name | Description | Required |
---|---|---|
Object type | Type of object (this is an Oracle type) | Yes |
Object name | Name of object | Yes |
liquibase(lb) genschema
Name | Description | Required |
---|---|---|
Public synonym | Capture public synonyms. Default is false. | No |
Grants | Capture grants. Default is false. | No |
liquibase(lb) gencontrolfile
master.xml
, with a placeholder to include files in the current working directory. You can use this command when you are creating you own changelog with custom changeset inclusions. liquibase(lb) update <CHANGE LOG> {include schema}
TRUE
for include schema. The default value is FALSE
. liquibase(lb) updatesql <CHANGE LOG> {include schema}
TRUE
for include schema. The default value is FALSE
. liquibase(lb) rollback <CHANGE LOG> <COUNT>
liquibase(lb) diff <DEST URL> <DEST USER> <DEST PASS> {report}
liquibase(lb) status <CHANGE LOG>
liquibase(lb) validate <CHANGE LOG>
liquibase(lb) changelogsync <CHANGE LOG>
liquibase(lb) listlocks <CHANGE LOG>
liquibase(lb) releaselocks <CHANGE LOG>
liquibase(lb) clearchecksums <CHANGE LOG>
liquibase(lb) help <COMMAND>
ChangeSet | Description |
---|---|
CreateOracleConstraint | Creates a constraint from SQL. |
CreateOracleFunction | Creates a function from SQL. |
CreateOracleGrant | Creates a grant from SQL. |
CreateOraclePackageBody | Creates a package body from SQL. |
CreateOraclePackageSpec | Creates a package specification from SQL. |
CreateOracleProcedure | Creates a procedure from SQL. |
CreateOraclePublicSynonym | Creates a public synonym from SQL. |
CreateOracleRefConstraint | Creates a referential constraint from SQL. |
CreateOracleSynonym | Creates a synonym from SQL. |
CreateOracleTrigger | Creates a trigger from SQL. |
CreateOracleTypeBody | Creates a type body from SQL. |
CreateOracleTypeSpec | Creates a type spec from SQL. |
CreateSxmlObject | Creates a function from SQL. |
DropOracleConstraint | Drops a constraint. |
DropOracleFunction | Drops a function. |
DropOracleGrant | Drops a grant. |
DropOraclePackageBody | Drops a package body. |
DropOraclePackageSpec | Drops a package specification. |
DropOracleProcedure | Drops a procedure. |
DropOracleRefConstraint | Drops a referential constraint. |
DropOracleTrigger | Drops a trigger. |
DropOracleTypeBody | Drops a type body. |
DropOracleTypeSpec | Drops a type specification. |
DropOracleSynonym | Drops a synonym. |
DropSxmlObject | Drops an SXML object. If the object was created through createSxmlObject, this rolls back the object to the last state. If not created, the object is just dropped. This is primarily used internally for SXML object handling. |
RunOracleScript | Runs an Oracle script. |
false
or it will try and create the object in the HR schema.