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 <[EMAIL PROTECTED]> wrote: > On 9/13/07, Robert Björn <[EMAIL PROTECTED]> 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 >
