Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Is there any way to query the information stored in the redo logs?
Hi,
While I am sure that there are other ways of solving your problem the following is an efficient approach that will allow you to identify the added and changed rows:
SELECT column1, column2, ... columnn FROM current_table MINUS SELECT column1, column2, ... columnn FROM original_table;
The results will show every row in the current table which has either been added or changed since the original table was created.
regards
Jerry Gitomer
Mr.TT. wrote in message <7j1pg4$de6$1_at_lola.ctv.es>...
>Hello. The thing is i need to know the list of rows of a table that have
>been modified from a past date to today. The problem is that the tape with
>the backup of that information have been reused (in my organization they
>only preserve the tapes for two months - I know this is not the best, but
>its what they done). We have the database in archive mode, so i have all
the
>logs. The information of all the transactions done is stored there, so i
>wonder if there is a way to query that information.
>
>Any help will be welcome and have my anticipated thanks in advance.
>
>TT
>
>
Received on Thu Jun 03 1999 - 11:10:06 CDT