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

As a minor variant on Brian's suggestion.

If you are unable to add columns to the table because it belongs to a 3rd party app, you may still be able to add a trigger which traps the primary key and uses it to update (insert/mark as deleted) rows on a parallel table.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison-Wesley
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
More reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



Brian Peasland wrote in message <3A5B1B75.371CD79F_at_edcmail.cr.usgs.gov>...


>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!

>========================================