Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 93EFC3931 for ; Mon, 2 May 2011 15:58:50 +0000 (UTC) Received: (qmail 50921 invoked by uid 500); 2 May 2011 15:58:50 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 50884 invoked by uid 500); 2 May 2011 15:58:50 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 50877 invoked by uid 99); 2 May 2011 15:58:50 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 02 May 2011 15:58:50 +0000 X-ASF-Spam-Status: No, hits=-2.3 required=5.0 tests=RCVD_IN_DNSWL_MED,SPF_PASS,UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (athena.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; Mon, 02 May 2011 15:58:41 +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 p42FwIm1018193 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK) for ; Mon, 2 May 2011 15:58:20 GMT Received: from acsmt357.oracle.com (acsmt357.oracle.com [141.146.40.157]) by acsinet15.oracle.com (Switch-3.4.2/Switch-3.4.1) with ESMTP id p42FwHZ4007802 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO) for ; Mon, 2 May 2011 15:58:17 GMT Received: from abhmt007.oracle.com (abhmt007.oracle.com [141.146.116.16]) by acsmt357.oracle.com (8.12.11.20060308/8.12.11) with ESMTP id p42FwGW3030002 for ; Mon, 2 May 2011 10:58:16 -0500 Received: from richard-hillegas-computer.local (/10.159.30.126) by default (Oracle Beehive Gateway v4.0) with ESMTP ; Mon, 02 May 2011 08:58:16 -0700 Message-ID: <4DBED48E.6050506@oracle.com> Date: Mon, 02 May 2011 08:58:06 -0700 From: Rick Hillegas User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.5; en-US; rv:1.9.2.13) Gecko/20101207 Thunderbird/3.1.7 MIME-Version: 1.0 To: "derby-dev@db.apache.org" Subject: truncating a table vs online backup Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Source-IP: acsinet15.oracle.com [141.146.126.227] X-Auth-Type: Internal IP X-CT-RefId: str=0001.0A090206.4DBED49C.00B2:SCFMA922111,ss=1,fgs=0 According to the Admin Guide, uncommitted unlogged operations prevent you from starting an online backup. These unlogged operations include index creation and bulk import. An uncommitted TRUNCATE TABLE does not block online backup. Is that OK? Thanks, -Rick