Hello
I’m diffing two schemas in Oracle 10g using Liquibase 2.0.1 plus the ojdbc6.jar thin driver.
My problem:
all works fine, but foreign keys are defined in the schema where I’m diffing FROM.
I need a neutral (schema independent) definition.
How can I achieve that?
Am I doing something wrong?
<changeSet
author=“luigi (generated)”
id=“1305109016679-45”>
baseColumnNames=“TYPE_ID”
baseTableName=“MY_TABLE”
baseTableSchemaName=“SCHEMA_FROM”
constraintName=“MY_FK”
deferrable=“false”
initiallyDeferred=“false”
onDelete=“RESTRICT”
referencedColumnNames=“ID”
referencedTableName=“MY_REFERENCED_TABLE”
referencedTableSchemaName=“SCHEMA_FROM”
referencesUniqueColumn=“false”>
Regards
–luigi