Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 29264 invoked from network); 5 Jul 2006 23:04:19 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 5 Jul 2006 23:04:19 -0000 Received: (qmail 47165 invoked by uid 500); 5 Jul 2006 23:04:17 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 47142 invoked by uid 500); 5 Jul 2006 23:04:17 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 47131 invoked by uid 99); 5 Jul 2006 23:04:17 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Jul 2006 16:04:17 -0700 X-ASF-Spam-Status: No, hits=1.9 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [32.97.110.151] (HELO e33.co.us.ibm.com) (32.97.110.151) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Jul 2006 16:04:16 -0700 Received: from d03relay04.boulder.ibm.com (d03relay04.boulder.ibm.com [9.17.195.106]) by e33.co.us.ibm.com (8.12.11.20060308/8.12.11) with ESMTP id k65N3tHp007781 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=FAIL) for ; Wed, 5 Jul 2006 19:03:55 -0400 Received: from d03av02.boulder.ibm.com (d03av02.boulder.ibm.com [9.17.195.168]) by d03relay04.boulder.ibm.com (8.13.6/NCO/VER7.0) with ESMTP id k65N4HxX144776 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Wed, 5 Jul 2006 17:04:17 -0600 Received: from d03av02.boulder.ibm.com (loopback [127.0.0.1]) by d03av02.boulder.ibm.com (8.12.11.20060308/8.13.3) with ESMTP id k65N3tAF000615 for ; Wed, 5 Jul 2006 17:03:55 -0600 Received: from [127.0.0.1] (MARSDEN-IBM-LT1.usca.ibm.com [9.72.134.57]) by d03av02.boulder.ibm.com (8.12.11.20060308/8.12.11) with ESMTP id k65N3rr8000546 for ; Wed, 5 Jul 2006 17:03:55 -0600 Message-ID: <44AC4557.1040608@sbcglobal.net> Date: Wed, 05 Jul 2006 16:03:51 -0700 From: Kathey Marsden User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.13) Gecko/20060414 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Discussion Subject: Re: Migrating CLOBs to new DB schema References: <44AC43B8.3040202@brighton.ac.uk> In-Reply-To: <44AC43B8.3040202@brighton.ac.uk> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N John English wrote: > I have a database where I need to change the schema for a couple of > crucial > tables. This involves changing the types of some fields, so I can't > just do > an "alter table". The tables contain CLOBs, so I can't use the > provided SYSCS > export/import procedures. [snip what John tried] > > Any other ideas that I could try? > I had great luck recently with DDLUtils. I hit one small issue with zero length Clobs which I think is resolved now. http://db.apache.org/derby/integrate/db_ddlutils.html Kathey