Re: Oracle data change history ?
From: gazzag <gareth_at_jamms.org>
Date: Wed, 26 Aug 2009 05:51:53 -0700 (PDT)
Message-ID: <ce3b9d1b-67c7-4dbe-8774-42e53f7bf4fe_at_f37g2000yqn.googlegroups.com>
On 26 Aug, 12:58, grz01 <gr..._at_spray.se> wrote:
> Hi,
>
> We are building a new application with Java/Spring, Hibernate and
> Oracle.
>
> One requirement is to be able to trace back the history of all objects
> (table-rows) in the database and see how they looked at a certain
> point back in time.
> We also need to know who changed what, and when -- but "who" is
> determined by programming-logic (not the userid in Oracle) so I guess
> that info has to be stored along in the database-tables.
>
> The flashback-feature in Oracle seems to have the general
> functionality we want, but being based on redo-logs, etc, I guess it's
> not useful if you want to retain all history going back, say, 24
> months, or so?
>
> Is there some other feature or framework (from Oracle, a third-party
> or open-source) suitable for this purpose?
>
> TIA, grz
Date: Wed, 26 Aug 2009 05:51:53 -0700 (PDT)
Message-ID: <ce3b9d1b-67c7-4dbe-8774-42e53f7bf4fe_at_f37g2000yqn.googlegroups.com>
On 26 Aug, 12:58, grz01 <gr..._at_spray.se> wrote:
> Hi,
>
> We are building a new application with Java/Spring, Hibernate and
> Oracle.
>
> One requirement is to be able to trace back the history of all objects
> (table-rows) in the database and see how they looked at a certain
> point back in time.
> We also need to know who changed what, and when -- but "who" is
> determined by programming-logic (not the userid in Oracle) so I guess
> that info has to be stored along in the database-tables.
>
> The flashback-feature in Oracle seems to have the general
> functionality we want, but being based on redo-logs, etc, I guess it's
> not useful if you want to retain all history going back, say, 24
> months, or so?
>
> Is there some other feature or framework (from Oracle, a third-party
> or open-source) suitable for this purpose?
>
> TIA, grz
Take a look at Fine-Grained Auding:
http://download.oracle.com/docs/cd/B19306_01/network.102/b14266/cfgaudit.htm#i1011302
HTH -g Received on Wed Aug 26 2009 - 07:51:53 CDT