Home » SQL & PL/SQL » SQL & PL/SQL » as of Timestamp and Flashback Setting
as of Timestamp and Flashback Setting [message #208364] Sat, 09 December 2006 20:15 Go to next message
orasaket
Messages: 70
Registered: November 2006
Member
Hi,
i am using Oracle 9i R2 on Linux

i want to know how to query back the committed data using as of timestamp and how much back it can be queried.

Does it depends on flashback time?

Thanks and Regards,
OraSaket
Re: as of Timestamp and Flashback Setting [message #208434 is a reply to message #208364] Sun, 10 December 2006 20:28 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Does the doco help?

Ross Leishman
Re: as of Timestamp and Flashback Setting [message #209207 is a reply to message #208434] Wed, 13 December 2006 15:40 Go to previous message
orasaket
Messages: 70
Registered: November 2006
Member
Many thanks Ross for the useful Link and quick response

Regards
OraSaket
Previous Topic: 2 inner queries in select statement??
Next Topic: Figuring out weekly counts
Goto Forum:
  


Current Time: Thu Dec 08 18:43:49 CST 2016

Total time taken to generate the page: 0.06676 seconds