Flashback Status Tips

welcome to http://www.startdays.com
welcome to http://www.ijachouf.com
welcome to http://www.swtools.biz
welcome to http://www.decoderhd.com

Oracle Flashback Status Tips

Oracle Tips by Burleson Consulting
June 21, 2011

Question: I want to figure out which tables are currently enable for
Oracle flashback. Is there a query that can tell me the flashback
status of each tablespace in my database?

Answer: Querying the flashback status of your tablespaces can be
accomplished using the v$tablespace view. The following query will
return the flashback status for each tablespace:

select
---------------------------------------------------------------
---------------------------------------------------------------
---------------------------------------------------------------