Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Replicating large tables
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