Re: How can i select the new(or newly updated) records if there is no timestamp filed in my table?

Bill,

You can use Logminer to help you, but it's a long road to travel.

If you really have a requirement that you need to know when a row was inserted or updated, then you'll need to include another column in your table with the timestamp. You can then use a trigger to update the timestamp on INSERT or UPDATE.

HTH,
Brian

"newshost.unx.sas.com" wrote:
>
> How can i select the new(or newly updated) records if there is no timestamp
> filed in my table of Oracle Database?
>
> Are there any Oracle system options that i can trace these records?Or exist
> other tools to help me?
>
> Thanks,
>
> Bill Ding,
> Oracle Developer
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================