Re: To get delayed data?

Simo Silmu wrote:
> Hi all,
>
> one consultant working for us would like to create a view (based on two
> tables) which will retrieve data what is delayed - lets say 30mins.
>
> How to do this?
>
> Using materialized view
> or
> Using flashback query, how to implement with this?
>
> Thank you in advance
>
> Cheers
> SS
>
>

The best approach is to use a Flashback Query and flash back to 30 minutes ago. You'll need to ensure that you have enough UNDO_RETENTION to allow this operation. The following document shows you how to create a FLASHBACK QUERY:

http://download-east.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_flashback.htm#i1020531

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown