9.12.6 clear-checksums

Clears all checksums and nullifies the MD5SUM column of the DATABASECHANGELOG table so that they will be recomputed on the next database update.

Syntax

Liquibase|lb clear-checksums|clc {OPTIONS}

Options

Option Description Default
-database-changelog-table-name|-dactn Name of table to use for tracking change history. -
-debug|-de Enable debug output. -
-default-schema-name|-desn <default-schema-name> The default schema name to use for the database connection. -
-defaults-file|-def <defaults-file> {FILE} Fully qualified path to the properties file you want to use. Example: -defaults-file/tmp/liquibase.properties -
-liquibase-schema-name|-lbsn <liquibase-schema-name> Schema to use for Liquibase objects. -
-liquibase-tablespace-name|-lbtn <liquibase-tablespace-name> Tablespace to use for Liquibase objects. -
-log|-lo

Enable logging.

Standard logging is INFO level (no debug flag).

Debug logging is FINEST level (both log and debug flag).

-
-secure-parsing|-scp

If true, remove functionality from file parsers that could be used insecurely.

An example is disabling remote XML entity support.

True
-output-default-schema|-ouds Control whether names of objects in the default schema are fully qualified or not. If false, only objects outside the default schema are fully qualified. False

Example

Clear checksums:

-- Connect to target and execute command.
SQL> connect <db-connect-string> 
SQL> clear-checksums