Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 22246 invoked from network); 18 Nov 2010 21:15:52 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 18 Nov 2010 21:15:52 -0000 Received: (qmail 38835 invoked by uid 500); 18 Nov 2010 21:16:23 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 38653 invoked by uid 500); 18 Nov 2010 21:16:22 -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 38381 invoked by uid 99); 18 Nov 2010 21:16:22 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 18 Nov 2010 21:16:22 +0000 X-ASF-Spam-Status: No, hits=-2.3 required=10.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS,UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [148.87.113.121] (HELO rcsinet10.oracle.com) (148.87.113.121) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 18 Nov 2010 21:16:13 +0000 Received: from acsinet15.oracle.com (acsinet15.oracle.com [141.146.126.227]) by rcsinet10.oracle.com (Switch-3.4.2/Switch-3.4.2) with ESMTP id oAILFofE031867 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK) for ; Thu, 18 Nov 2010 21:15:52 GMT Received: from acsmt355.oracle.com (acsmt355.oracle.com [141.146.40.155]) by acsinet15.oracle.com (Switch-3.4.2/Switch-3.4.1) with ESMTP id oAIGiTYg010018 for ; Thu, 18 Nov 2010 21:15:48 GMT Received: from abhmt020.oracle.com by acsmt355.oracle.com with ESMTP id 790123431290114885; Thu, 18 Nov 2010 13:14:45 -0800 Received: from localhost (/129.159.112.235) by default (Oracle Beehive Gateway v4.0) with ESMTP ; Thu, 18 Nov 2010 13:14:44 -0800 From: dag.wanvik@oracle.com (Dag H. Wanvik) To: Derby Discussion Subject: Re: Derby database backup and restore References: <30239556.post@talk.nabble.com> Date: Thu, 18 Nov 2010 22:14:42 +0100 In-Reply-To: <30239556.post@talk.nabble.com> (vipinsudhakar's message of "Wed, 17 Nov 2010 23:24:27 -0800 (PST)") Message-ID: User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1 (usg-unix-v) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Checked: Checked by ClamAV on apache.org Hi, vipinsudhakar writes: > Does full upgrade provide the facility of increasing page size? If > not I have to take the back up of the derby db of older version and create a > new database with newer version along with increase in page size and just > import the data into my latest derby database version. Cf derby.storage.pageSize as described here: http://db.apache.org/derby/docs/10.6/ref/rrefproper40688.html "This value will be used for the lifetime of the newly created conglomerates." So upgrading won't change the pageSize. You could use a temporary table and recreate the table to get the pageSize you want, or use backup/restore, but you will have to recreate it. Thanks, Dag