Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Timestamp
Also look into refresh -snapshots
Wade
QuestionExchange <USENET_at_questionexchange.com> wrote in message
news:2583qx_at_questionexchange.com...
> Isabelle,
> Add a last_updated date column to the table(s)
> Create a before row trigger for update and insert on the
> table(s) which sets
> new.last_updated := sysdate;
> this will cause the last_updated column to be changed.
> Becca
> > 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.
> >
> >
>
> --
> This answer is courtesy of QuestionExchange.com
>
http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=7483&cus_id=USE
NET&qtn_id=7994
Received on Tue Nov 09 1999 - 04:57:33 CST