I don't think that your proposed structure will work very well. how are you
going to store numbers,dates and text in one column (old_value say). Let
alone any object or large binary datatypes. In addition you will have to
create (as I see it) a trigger on every single table storing all data for
that tables changed rows twice (before and after change). So you will need
to multiply your storage requirements by say a factor of ten and accept a
considerable slowdown in performance.
I'd suggest you go back to the authors of the request and ask what data they
are actually interested in seeing an audit trail for.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Stefan Poschenrieder" <stefanp_at_raysono.com> wrote in message
news:3BC40972.1D5B9D5C_at_raysono.com...
> Hi there,
>
> we are asked to make a protocol of EVERY (!!) change in database like
> this:
>
> table column old-value new-value
>
> whats the easiest way to solve this "problem"..
>
> many thanks...
> Stefan
>
>
Received on Wed Oct 10 2001 - 08:34:23 CDT
