RE: Recently changed table

Hi=20

>Let me rephrase . I would like to know, is there a way
>to find out which table had been change at some point
>in time. For example, i have an web base customer
>complain application, I add a new customer complain
>from web based. From the database, i would like to
>know which table this customer complain added to.

I agree with Lex... i.e. you should use SQL tracing, this is the simpler = way.=20

Other possibilities:
- use flashback version query pseudocolumns to extract the timestamp of = last modification for each table (only available in 10g)=20 - give a look to the redo logs with the logminer or, if you are in 10g, = with flashback_transaction_query.

HTH
Chris

--
http://www.freelists.org/webpage/oracle-l