Technical Notes

We're all on the same page!

Showing posts with label flashback. Show all posts
Showing posts with label flashback. Show all posts
Friday, 21 April 2017

How to restore database object such as package body via flashback?

›
Note that below SQL gets output if it is still in UNDO tablespace. SQL>  SELECT text  FROM all_source         AS OF TIMESTAMP TO_TIME...
Monday, 19 December 2016

How to rollback committed data from flashback?

›
To Check SQL> SELECT *   FROM HR.EMPLOYEES        AS OF TIMESTAMP TO_TIMESTAMP ('2016-12-19 21:35:00', 'YYYY-MM-DD HH24:...
›
Home
View web version
Powered by Blogger.