Re: Does Oracle Have a Way to Store Historical Changes to Records?

Noons wrote:
>
> Maxim Demenko apparently said,on my timestamp of 4/08/2005 6:21 AM:
>
> > Alot of suggestions was made, just to complete...
> > Oracle Workspace Manager
> > (http://www.oracle.com/technology/obe/obe9ir2/obe-cnt/spatial/spatial.htm)
>
> I was going to suggest that one as well. Seems to be just
> what the doc ordered, with minimal development.
> Anyone tried it and is it as buggy as all the new features?
>
> --
> Cheers
> Nuno Souto
> in sunny Sydney, Australia
> wizofoz2k_at_yahoo.com.au.nospam

Works as expected, but when you version enable a table, you get something like 12 new objects surrounding that table, because WM gives you a LOT more goodies that you probably need to just capture changes.

So the options tend to be:

1. triggers
2. DBMS_WM
3. streams

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"Semper in excremento, sole profundum qui variat."

------------------------------------------------------------