From ddlutils-user-return-108-apmail-db-ddlutils-user-archive=db.apache.org@db.apache.org Tue Jan 31 12:34:15 2006 Return-Path: Delivered-To: apmail-db-ddlutils-user-archive@www.apache.org Received: (qmail 61383 invoked from network); 31 Jan 2006 12:34:12 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 31 Jan 2006 12:34:12 -0000 Received: (qmail 56307 invoked by uid 500); 31 Jan 2006 12:33:59 -0000 Delivered-To: apmail-db-ddlutils-user-archive@db.apache.org Received: (qmail 56265 invoked by uid 500); 31 Jan 2006 12:33:59 -0000 Mailing-List: contact ddlutils-user-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ddlutils-user@db.apache.org Delivered-To: mailing list ddlutils-user@db.apache.org Received: (qmail 56237 invoked by uid 99); 31 Jan 2006 12:33:59 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Jan 2006 04:33:59 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of tomdzk@gmail.com designates 66.249.92.207 as permitted sender) Received: from [66.249.92.207] (HELO uproxy.gmail.com) (66.249.92.207) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 31 Jan 2006 04:33:58 -0800 Received: by uproxy.gmail.com with SMTP id m2so235771ugc for ; Tue, 31 Jan 2006 04:33:37 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=gkQvaGakGkOpPOIaboydhnOquHm6kjv8fMCkvbQ4SBKmgaLkx8VAz5YPZXOU+NP4FuqS9Bg9ENYebPOSL/q16SCvTuRTTd0FTidikOt+x9tzwax848NsbYFMZSBDSKPQn+YMGV4wWBISMGsgERfCtTgAwVvlD0JCE5SzyhJLZg8= Received: by 10.66.243.20 with SMTP id q20mr1795054ugh; Tue, 31 Jan 2006 04:33:37 -0800 (PST) Received: by 10.67.30.2 with HTTP; Tue, 31 Jan 2006 04:33:37 -0800 (PST) Message-ID: <224f32340601310433ubc8c358rd7c95f621ac9e5ab@mail.gmail.com> Date: Tue, 31 Jan 2006 13:33:37 +0100 From: Thomas Dudziak To: ddlutils-user@db.apache.org Subject: Re: oracle database model dangerously broken In-Reply-To: <43DF5461.9010600@informaticsmatters.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <43DF5461.9010600@informaticsmatters.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N On 1/31/06, Tim Dudgeon wrote: > If you read the model of an Oracle database and then try an > alterTables() with this unchanged model DDLUtils incorrectly thinks it > needs to make lots of changes to the database and can corrupt the > database. For instance if you do this: > > Database db =3D platform.readModelFromDatabase("test", null, "MYSCHEMA", > null); > platform.alterTables(db, false, false, false); > > then DDLUtils want to make lots of changes to the database, even though > you have made no changes at all. > I do NOT recommend you try this for yourself! Please be more specific, e.g. post an original model and what DdlUtils reads back. Tom