Home » Server Options » Replication » Table Replication.
Table Replication. [message #171475] Wed, 10 May 2006 02:54 Go to next message
ark1974
Messages: 2
Registered: December 2005
Junior Member
ORACLE 8i;

I have table h (history) it contains 20 million records. insert/update/delete on h every day about 2Million records.

i want to do access data one set until esterday (End of the day)
(T-1).
another set is upto date(T).

considering following ways:
a) Snapshots (Materialized views)
b) Create audit table
c) Storing today transactions in different table and Transfer at EOD.

question:
1) If i use snapshot(MV) there is dependency when refreshing.
e.g. DML on table h depends on snapshot refresh How to prevent this?


2) option is b, c are my choices but involve programming.
please advice which is best option (any).

Thanks.

Kaithy Aravind Reddy.

Re: Table Replication. [message #175209 is a reply to message #171475] Thu, 01 June 2006 05:06 Go to previous message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
In case, you plan to use replication, then create snapshot & use fast refresh opion for its refreshing.
Create snapshot log on master table.

Make the refresh time at EOD. That should serve your purpose.

--Girish
Previous Topic: PLEASE HELP ME ASAP - Refreshing materialized view at Oracle replication sites
Next Topic: Setting up Replication
Goto Forum:
  


Current Time: Fri Jul 30 07:49:09 CDT 2021