Timestamp

From: Isabelle <isafz_at_my-deja.com>
Date: Wed, 03 Nov 1999 13:29:46 GMT
Message-ID: <7vpdc7$q1e$1@nnrp1.deja.com>

All,

I am working for a new datawarehouse project and I am currently exploring how we can transfer data from one db to another. Source DB is currently under Oracle.

When I connect to the source DB I would like to know what has changed since my last connection. Currently the application who is managing this DB does not handle that.

I heard there is perhaps a method / option in the Oracle system to indicate that we want for each row to keep a timestamp.

Could someone give me indication on : how to put this system in place and then how to retrieve the information ?

Thanks by advance
Isabelle.

-- -- -- -- -- -- Isabelle Fernandez Datawarehouse Project SEMA Group, Sophia Antipolis, France

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 03 1999 - 07:29:46 CST