Re: When last changed?

"Chris Neubauer" <water.world_at_gmx.de> wrote in message news:<9n7kv2$5qqcj$1_at_ID-76747.news.dfncis.de>...
> Hi,
>
> how can I find out when a table was changed (i.e. insert/update/delete) for
> the last time?
>
> Regards,
> Chris

I do not believe that Oracle keeps track of this information as such. There are ways you can find or track this. Note your question is at the object level so I will address the subject at that level.

1- You could use log miner to scan the redo logs for the information but if the last change was days ago this is not practical

2- You can place triggers on your objects to record this and in the case of row level changes you can add columns for user_id and last_change time to them so
you can capture this, but you are not going to want to do this for everything.

3- You can use the audit command to record DML activity by access or by session and query the audit trail.

4- Dba_tables contains an indicator if the table has been updated since its last export (backed_up) and dba_objects has the date the last DDL statement was ran against the object plus creation but not for DML activity.

Item 3 is probably your best bet if you need to track certain tables.

I hope this helps.

• Mark D Powell --