incremental updates in oracle 9i.
418934May 19 2004 — edited May 23 2004Hi all,
We got two database
1. Production,
2. Mis(This has group of tables from production and other db also),
We Have to update on daily basis a group of tables from production db to MIS(which has subset of production db + other tables).
On daily basis the data from production is available as export dumps.
Note: In 9i no Incremental import..
Also I dont want to use Rman utility tool.
Now my requirement is,
How to update the tables in Mis db as like in Production DB.
Thnks and Regards
S. Djeanthi