Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Replicating large tables

Re: Replicating large tables

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 16 Feb 2006 06:56:58 +0100
Message-ID: <cu48v11c0u4m75vop7g6pb2oa9h9en1qqh@4ax.com>


On 15 Feb 2006 20:57:15 -0800, "Edwinah63" <edwinah_at_customercare.com.au> wrote:

>start replication from record 4
>
>is this possible?
>
>if so, how do i achieve this?

Yes with adding a materialized view log and issuing fast refresh instead of complete refresh.
Note : the export import method would be definitely *slower*.

Just read the manuals, and have some patience.

--
Sybrand Bakker, Senior Oracle DBA
Received on Wed Feb 15 2006 - 23:56:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US