-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Using the following query one can see the flashback data available. SELECT to_char(sysdate,'YYYY-MM-DD HH24:MI') current_time, to_char(f.oldest_flashback_time, 'YYYY-MM-DD HH24:MI') OLDEST_FLASHBACK_TIME, (sysdate… READ MORE
In 10g oracle has introduced the concept of recycle bin one can recover tables that were dropped. When a table… READ MORE
In 10g using dbms_flashback one can flashback using timestamp or SCN. If a user accidentally deletes rows or updates rows… READ MORE
One of the features in 10g is flashback which allows to restores tables that were dropped. Note: If an index… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 