| Table Replication. [message #171475] |
Wed, 10 May 2006 02:54  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
