Thursday 14 May 2015

How to restore a table from an Oracle flashback snap shot?




To just Query a snapshot:
SELECT * FROM MY_SCHEMA.MY_TABLE AS OF TIMESTAMP TO_TIMESTAMP('2015-05-11 18:00:00', 'YYYY-MM-DD HH24:MI:SS');


To Take a Snapshot and Dump to another table:
Create table MY_SCHEMA.MY_TABLE_TEMP as 
SELECT * FROM MY_SCHEMA.MY_TABLE AS OF TIMESTAMP TO_TIMESTAMP('2015-05-11 18:00:00', 'YYYY-MM-DD HH24:MI:SS');

No comments:

Post a Comment