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

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Wed, 03 Aug 2005 22:21:30 +0200
Message-ID: <dcr8vl$u0u$03$1@news.t-online.com>

GeoPappas schrieb:
> I am sure it does, but I am not sure of its marketing name.
>
> Say you have a record that was created and now a user has edited the
> record. Does Oracle have a way of storing both the original record and
> modifications? Sort of like an audit trail or history of changes.
>
> For example, say you have a table with the following columns:
>
> DATA VARCHAR2(25)
> UPDATE_USER VARCHAR2(10)
> UPDATE_DATE DATE
>
> At first, user ABC creates a record with DATA='HELLO' on 05/01/2005
> 06:30a.
>
> Next, user DEF changes DATA='HELLO AGAIN' on 05/02/2005 07:00a.
>
> Next, user XYZ changes DATA='GOODBYE' on 05/31/2005 09:45a.
>
> Could Oracle save all of those points, so that I could go back and look
> at any point in time?
>

Alot of suggestions was made, just to complete... Oracle Workspace Manager
(http://www.oracle.com/technology/obe/obe9ir2/obe-cnt/spatial/spatial.htm)

Best regards

Maxim Received on Wed Aug 03 2005 - 15:21:30 CDT