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 -> Replicating large tables

Replicating large tables

From: Edwinah63 <edwinah_at_customercare.com.au>
Date: 15 Feb 2006 20:57:15 -0800
Message-ID: <1140065835.319791.195090@z14g2000cwz.googlegroups.com>


Hi everyone,

I have a table (myTable) with approx 2 millions rows in it that i would like to start replicating.

what if find is that when i try to add this table to the materialized view group via the OEM GUI interface, it seems to take ages and eventually stalls without adding the the table to the group.

I am *guessing* that this is because a copy of myTable is being made on the MV site but rather than do this I would prefer to:

eg:

contents of mySchema.myTable when exported:

1 cat
2 dog
3 fish

import into schema mirror on MV site

now table has changed because users are still adding:

1 cat
2 dog
3 fish
4 gopher
5 ferret
6 puma

start replication from record 4

is this possible?

if so, how do i achieve this? i've googled around and couldn't find anything similar to what i wanted.

Edwinah63 Received on Wed Feb 15 2006 - 22:57:15 CST

Original text of this message

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