Versions Compared

Old Version 17

changes.mady.by.user JulienJ

Saved on

compared with

New Version 18

changes.mady.by.user Nathan Voxland

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: added ora xml example

...

To use, simply include the oracle-extentions.jar file in your classpath. And add the ora namespace to your xml root node:

Code Block

<databaseChangeLog
    xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns:ora="http://www.liquibase.org/xml/ns/dbchangelog-ext"
    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd
    http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd">

Available Commands/Tags

Panel

Add Check

Adds a check constraint to an existing table.

Sample
Code Block
xml
xml
<ora:addCheck tableName="person"
	condition="id between 0 and 5"
	disable="true"
	deferrable="true"
	initiallyDeferred="true"
/>
Available Attributes

tableName

Name of the table to add check constraint to [required]

schemaName

Name of the table schema

tablespace

Specify the tablespace in which the check constraint is to be created

condition

True/false expression [required]

constraintName

Name of the check constraint

deferrable

Is check deferrable

initiallyDeferred

Is check initially deferred

disable

Is check disabled

validate

Is check validate

rely

Is check rely

Automatic Rollback Support : YES

...