db-ddlutils-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Robert Björn" <rob...@objective.se>
Subject Re: System tables and foreign key constraints issues with Oracle
Date Fri, 14 Sep 2007 13:30:55 GMT
Hi Thomas,

That solved both of the problems. I thought that I had already tested
specifying the schema but I can only assume that I made some mistake
the first time. Thanks!

Regards,
Robert

On 9/14/07, Thomas Dudziak <tomdzk@gmail.com> wrote:
> On 9/13/07, Robert Björn <objective@robertb.eu> wrote:
>
> > a) The first problem is that while specifying the table types in the
> > readModelFromDatabase) call works fine -- I supply only the "TABLES"
> > type to avoid getting the system tables also -- this does not work for
> > alterDatabase(). As stated in the documentation, that argument affects
> > only what is being read and not what is being modified in the target
> > database. The result is that DdlUtils wants to remove all of the
> > system tables. I thus get "Error while executing SQL DROP TABLE
> > AUDIT_ACTIONS CASCADE CONSTRAINTS".
>
> For Oracle, you should specify the database schema when using Ant or
> the API (using the method variants that allow to specify the catalog
> and the schema). This way, system tables won't be visible to DdlUtils.
>
> > b) The second problem is that the foreign key constraints that I added
> > seem to result in DdlUtils wanting to add indices, for some reason
> > resulting in "Cannot write unnamed index".
>
> Could you provide some more info, e.g. the XML schema and the Ant
> build file or the code snippet if you're using the API ?
>
> Tom
>

Mime
View raw message