• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 600
  • Last Modified:

incremental update

How to approach incremental updates in data warehousing, where source database and the target database are Oracle 8.1.6? my OLTP System doesn?t have timestamp field
1 Solution

I'm using snapshot for this.
Just simple, not updatable.
(but our database is not too big, just to give the discoverer users their own database)

Be carefull with the update process, can take a lot of resources.

Basic snapshot: (ok there is some environment and init stuff but that well documented.)
1) create a logfile in source database
2) create db link in target
3) create snapshot ( select * from xxx@link)
(creates update process as well.)
If you use OEM 2.1 then there is a wizzard for this.
(in Oracle 8.1.7 it's part of the DBA studio)

good luck.

See documentation for REPLICATION.

Running OLTP system on and DataWarehouse on 8.1.7 had problems in replication. We wanted just to change the changes only to the Warehouse on  a weekly basis ( No Complete Refreshes). Created 2 synonyms for the table and inserted data into synonym 1 in week1 and then synonym 2 in week 2 . Ran a Delta between the two and inserted changes only. Crude but works
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.


i've been doing that here (prod 7.3.4) Snapshot 8.1.7,
no problem at all (exept a lot of tables without primary key, so i have to use Rowid for the fast update)


(and could you please post comments not answers, now the question gets locked)
Hi gopidevsurya,
It appears that you have forgotten this question. I will ask Community Support to close it unless you finalize it within 7 days.  I will suggest to:

    Accept jbever's comment(s) as an answer.

gopidevsurya, if you think your question was not answered at all or if you need help, you can simply post a new comment here.  Community Support moderators will followup.

Please do not accept this comment as an answer!

EXPERTS: Your input for closing recommendations are REQUESTED.
DanRollins -- EE database cleanup volunteer
Force accepted

** Mindphaser - Community Support Moderator **
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now