tags:

views:

248

answers:

3

How do I enable flashback queries for all of my developers on my Oracle instance?

Flashback queries are executed as of a particular time so that

select * from mytable as of timestamp(sysdate-1);

will show the contents of the table as of 24 hours ago.

+3  A: 
grant execute on dbms_flashback to public;
grant flashback any table to public;
Mark Harrison
+1  A: 

You can use flashback query for your own tables without needing any privileges. If you want other users to use flashback query on your tables you need to grant select and flashback privileges to those users.

If you want to see data as of 24 hours ago you need to have an adequately sized undo tablespace and properly set undo retention.

Also see this.

http://tinyurl.com/cwtylm

Yas