From ddlutils-user-return-454-apmail-db-ddlutils-user-archive=db.apache.org@db.apache.org Mon Jul 24 06:29:25 2006 Return-Path: Delivered-To: apmail-db-ddlutils-user-archive@www.apache.org Received: (qmail 81900 invoked from network); 24 Jul 2006 06:29:25 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 24 Jul 2006 06:29:25 -0000 Received: (qmail 82892 invoked by uid 500); 24 Jul 2006 06:29:25 -0000 Delivered-To: apmail-db-ddlutils-user-archive@db.apache.org Received: (qmail 82880 invoked by uid 500); 24 Jul 2006 06:29:25 -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 82752 invoked by uid 99); 24 Jul 2006 06:29:24 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 23 Jul 2006 23:29:24 -0700 X-ASF-Spam-Status: No, hits=0.5 required=10.0 tests=DNS_FROM_RFC_ABUSE,HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of allanjunli@gmail.com designates 66.249.92.173 as permitted sender) Received: from [66.249.92.173] (HELO ug-out-1314.google.com) (66.249.92.173) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 23 Jul 2006 23:29:23 -0700 Received: by ug-out-1314.google.com with SMTP id m2so2209724uge for ; Sun, 23 Jul 2006 23:29:02 -0700 (PDT) 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:references; b=FIJDzwKKVC2peAF99EqFdz3ugUP/feC2L7zMHRCHkvOrBHqRv/n5lPq751U2A6OiZ1UbX1p1H1tFwYJ9E6chWbBhsSXI9iWtreiZ1bb/aHPXYLeZnla2cbYW+9SBqebdvXOGlqB5TQlmHieu/uhrKn/t0TnnIlaxthZm5tB84bk= Received: by 10.66.221.19 with SMTP id t19mr3186058ugg; Sun, 23 Jul 2006 23:29:02 -0700 (PDT) Received: by 10.66.244.6 with HTTP; Sun, 23 Jul 2006 23:29:02 -0700 (PDT) Message-ID: Date: Mon, 24 Jul 2006 16:29:02 +1000 From: "Jun Li" To: ddlutils-user@db.apache.org Subject: Re: Potential object name conflict on Oracle. In-Reply-To: <224f32340607232237j54789d41q9be50bca9030019b@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_213586_4486478.1153722542262" References: <224f32340607232237j54789d41q9be50bca9030019b@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N ------=_Part_213586_4486478.1153722542262 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 1. Do we need sequence and trigger for those temp tables? 2. When truncate the object name, keep the two underlines characters rather than others. On 7/24/06, Thomas Dudziak wrote: > > On 7/23/06, Jun Li wrote: > > > Due to the limitation of maximum object name length (30) on Oracle, the > > script generated could have object name conflict. > > That is true, but there is nothing I can do about it. The problem is > that the name generation algorithm must create reproducable names, so > unique identifiers cannot be used. > A better way to handle this will be abailable once sequences/triggers > are directly supported by DdlUtils because you then can name them > yourself. > > Tom > -- -------------- Cheers, Jun ------=_Part_213586_4486478.1153722542262--