[Liquibase-user] New Topic: Different schema databse in oracle

[Liquibase Community Forum]

A new topic, 'Different schema databse in oracle', has been made on a board you are watching.

You can see it at
http://liquibase.org/forum/index.php?topic=843.new#new

The text of the topic is shown below:

Hi all friends. I am using liquibase 2.0.
I work with a database oracle (as reference db) which has an 'intranet' schema name.
I want to perform a diffChangeLog with oracle production database which has a different schema name: 'medical'.

When I perform the diffChangeLog I find this statement in xml file generated by liquibase:

<changeSet author="picasso (generated)" id="1292515368759-10">
<addForeignKeyConstraint
baseColumnNames="ID"
baseTableName="TABLE1"
baseTableSchemaName="INTRANET"
constraintName="TABLE1_FK"
deferrable="false" initiallyDeferred="false"
onDelete="RESTRICT" referencedColumnNames="ID_REF"
referencedTableName="TABLE2"
referencedTableSchemaName="INTRANET"
referencesUniqueColumn="false" />
</changeSet>

The schema INTRANET doesn't exist on production db (ony 'medical' exists) so the script returns some errors when
I execute it.
Is it possible use any option to change prodution db schema name?

Thx a lot 4 your help.

E.

Unsubscribe to new topics from this board by clicking here: http://liquibase.org/forum/index.php?action=notifyboard;board=1.0

Regards,
The Liquibase Community Forum Team.