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
-
Learn
-
Resources
-
Free Tools
OSS Risk Scanner Database DevOps Risk AssessmentCheat Sheets
Snowflake + Liquibase Databricks + Liquibase -
eBooks
6 Liquibase Community Risks & How to Avoid Guide: SOC 2 Compliance at the Database Layer Guide: Quantify the Value of Liquibase Secure -
Comparison Guides
Liquibase vs. Flyway Liquibase vs. Bytebase Liquibase Community vs Liquibase Secure
-
- Quickstart
- Get Started
- Documentation
- University
-
Resources
- Connect
- Contribute
- Join
- Blog