dbms_logstdby.instantiate_table

From: Jason Heinrich <jheinrichdba_at_gmail.com>
Date: Mon, 26 Jan 2009 11:32:33 -0600
Message-ID: <b32e774d0901260932o33f07496uc2e2b05998bb9bf9_at_mail.gmail.com>



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

--

http://www.freelists.org/webpage/oracle-l Received on Mon Jan 26 2009 - 11:32:33 CST

Original text of this message