...
Replace scripts work for different types of "non-rerunnable" changes:
- DDL - replace a set of scripted changes with a different script. DML - replace changes that remove records or insert records.folder or packageMethod=CONVERT
- DATA_DML folder or packageMethod=DATA_DML
- SQL_DIRECT folder or packageMethod=DIRECT
- SQL folder or packageMethod=SQLFILE
- Liquibase changelogs - replace the changesets packaged from the original changelog with changesets from the replacement changelog.
Cleanup and/or Replace are NOT recommended for stored logic (code: package, packagebody, procedure, function, trigger, view folders)
...
. Use the provided versioning capability with stored logic instead.
Replacing Changesets
For a file named myscript.sql
, create a replace file that contains the code to replace what was deployed before. Use one of the following forms:
...
Deployment Packager processes the -replace files during packaging, as follows:
...