Re: updated rows

From: <Kenneth>
Date: Wed, 26 Jan 2005 21:05:17 GMT
Message-ID: <41f8027a.1759453@news.inet.tele.dk>

On Wed, 26 Jan 2005 11:28:17 -0500, "hastenthunder" <hastenthunder_at_hotmail.com> wrote:

>Hello,
>
>Is there a easy way for a DBA to get all the rows in a particular table that
>have been updated since a specified timestamp?
>
>Thanks
>
>
>

Just a supplement to what Thomas wrote :

If you only need to track changes within "recent time", you can flashback directly by means of the handy view FLASHBACK_TRANSACTION_QUERY : SQL> create table foo as select * from dba_objects where rownum <=100;

Tabel er oprettet.

SQL> update foo set object_id=-1 where rownum = 1;

1 rµkke er opdateret.

SQL> commit;

Bekrµftelse er udf°rt.

SQL> select undo_sql from flashback_transaction_query where table_name = 'FOO';

UNDO_SQL

---

update "A"."FOO" set "OBJECT_ID" = '20' where ROWID = 'AAAKN4AABAAALHaAAA';

This way you can track all DML's on the table and not just updates.

Be prepared for some response time on this, because FLASHBACK_TRANSACTION_QUERY fetches data directly from the undo segments ==> no indexing.

• Kenneth Koenraadt

Received on Wed Jan 26 2005 - 15:05:17 CST