Re: How to Determine if Table Modified

Wouter Verhelst wrote:
>
> In article <L9Wr5.14716$K4.579990_at_newsread1.prod.itd.earthlink.net>,
> "George cova" <nojunkmail_at_earthlink.net> writes:
> > How can I determined if an Oracle table was modified. In other words, I
> > would like to know if a record was entered, deleted,or modified. Is there
> > something in the Dictionary that I can query that will tell me like the last
> > dateTime table modified? Or maybe some other field or value that counts the
> > number of times table was modified?
>
> I believe Oracle does not do this. However, you can create a database
> trigger that will update a date-field (perhaps in another table) to
> implement this by yourself.
> Beware, though, that your trigger won't trigger itself, or you'll have
> an infinite loop.
>
> <snip reason>
>
> --
> 12:39am up 1:34, 3 users, load average: 2.22, 1.45, 1.22
>
> Voor een vertaling van Documentation/Configure.help naar het Nederlands:
> http://users.pandora.be/wouter.verhelst/configure.html
>
> You are an insult to my intelligence! I demand that you log off immediately.

Take a look at the MONITORING clause for tables (alter table etc). You get (an approximate) indication of how many changes have occurred.

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse