Received: (qmail 24331 invoked from network); 26 Jan 2009 11:34:44 -0600
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
  by static-ip-85-25-126-90.inaddr.intergenia.de with SMTP; 26 Jan 2009 11:34:43 -0600
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E2750B88820;
 Mon, 26 Jan 2009 12:34:42 -0500 (EST)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 01083-07; Mon, 26 Jan 2009 12:34:42 -0500 (EST)
Received: from turing.freelists.org (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 67BDFB8874B;
 Mon, 26 Jan 2009 12:34:42 -0500 (EST)
Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 26 Jan 2009 12:32:36 -0500 (EST)
Received: from localhost (localhost [127.0.0.1])	by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 78803B88B61	for <oracle-l@freelists.org>; Mon, 26 Jan 2009 12:32:36 -0500 (EST)
Received: from turing.freelists.org ([127.0.0.1])	by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)	with ESMTP id 00675-02 for <oracle-l@freelists.org>;	Mon, 26 Jan 2009 12:32:36 -0500 (EST)
Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.180])	by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8622FB88B5E	for <oracle-l@freelists.org>; Mon, 26 Jan 2009 12:32:34 -0500 (EST)
Received: by wa-out-1112.google.com with SMTP id j4so553968wah.2        for <oracle-l@freelists.org>; Mon, 26 Jan 2009 09:32:33 -0800 (PST)
MIME-Version: 1.0
Received: by 10.114.15.1 with SMTP id 1mr2510057wao.112.1232991153473; Mon, 26 	Jan 2009 09:32:33 -0800 (PST)
Date: Mon, 26 Jan 2009 11:32:33 -0600
X-Google-Sender-Auth: 5e24701b696aa835
Message-ID: <b32e774d0901260932o33f07496uc2e2b05998bb9bf9@mail.gmail.com>
Subject: dbms_logstdby.instantiate_table
From: Jason Heinrich <jheinrichdba@gmail.com>
To: Oracle List <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary=001636417e43b6cb2d0461661f98
X-archive-position: 14209
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: jheinrichdba@gmail.com
Precedence: normal
Reply-to: jheinrichdba@gmail.com
List-help: <mailto:ecartis@freelists.org?Subject=help>
List-unsubscribe: <oracle-l-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <oracle-l.freelists.org>
X-List-ID: oracle-l <oracle-l.freelists.org>
List-subscribe: <oracle-l-request@freelists.org?Subject=subscribe>
List-owner: <mailto:steve.adams@ixora.com.au>
List-post: <mailto:oracle-l@freelists.org>
List-archive: <http://www.freelists.org/archives/oracle-l>
X-list: oracle-l
X-Virus-Scanned: Debian amavisd-new at localhost.localdomain
--001636417e43b6cb2d0461661f98
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Can anybody tell me what type of lock dbms_logstdby.instantiate_table
creates on the primary database table, or point me to documentation that
does?  I have a large table (~3.2 million rows) that I need to
reinstantiate, but the primary database is part of a production system and I
want to impact it as little as possible.  Any other thoughts or gotchas I
should look for?

Environment:
Oracle 10.2.0.3 EE
Windows 2003

-- 
Jason Heinrich

--001636417e43b6cb2d0461661f98
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Can anybody tell me what type of lock dbms_logstdby.instantiate_table creat=
es on the primary database table, or point me to documentation that does?&n=
bsp; I have a large table (~3.2 million rows) that I need to reinstantiate,=
 but the primary database is part of a production system and I want to impa=
ct it as little as possible.&nbsp; Any other thoughts or gotchas I should l=
ook for?<br>
<br>Environment:<br>Oracle 10.2.0.3 EE<br>Windows 2003<br clear=3D"all"><br=
>-- <br>Jason Heinrich<br>

--001636417e43b6cb2d0461661f98--
--
http://www.freelists.org/webpage/oracle-l