René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Flashback [Oracle SQL]

SCN

flashback table my_table to scn 490932;

Timestamp

flashback table my_table to timestamp '2002-04-01 10:08:31';

Before drop

See also Recovering from human errors with Flashback DB. 
flashback table RB$$4902$TABLE$1 to before drop rename to rene.my_important_table