30th September, 2020
FLASHBACK TABLE the command allows point in time recovery of individual tables subject to the following requirements.
FLASHBACK ANY TABLEsystem privilege or have
FLASHBACKobject privilege on the table.
ALTER TABLE tablename ENABLE ROW MOVEMENT;).
The following example creates a table, inserts some data, and flashbacks to a point prior to the data insertion. Finally it flashbacks to the time after the data insertion.
CREATE TABLE flashback_table_test ( id NUMBER(10) ); ALTER TABLE flashback_table_test ENABLE ROW MOVEMENT; SELECT current_scn FROM v$database; CURRENT_SCN ----------- 715315 INSERT INTO flashback_table_test (id) VALUES (1); COMMIT; SELECT current_scn FROM v$database; CURRENT_SCN ----------- 715340 FLASHBACK TABLE flashback_table_test TO SCN 715315; SELECT COUNT(*) FROM flashback_table_test; COUNT(*) ---------- 0 FLASHBACK TABLE flashback_table_test TO SCN 715340; SELECT COUNT(*) FROM flashback_table_test; COUNT(*) ---------- 1
Flashback of tables can also be performed using timestamps.
FLASHBACK TABLE flashback_table_test TO TIMESTAMP TO_TIMESTAMP('2004-03-03 10:00:00', 'YYYY-MM-DD HH:MI:SS');
Inclined to build a profession as Oracle DBA Training? Then here is the blog post on, explore Oracle DBA Training
Flashback Database is a part of the backup & recovery enhancements in Oracle 10g Database that are called Flashback Features. The main purpose of Flashback Technology is to let you quickly recover from logical corruptions or user errors. Oracle Flashback Features include the following:
FLASHBACK TABLEstatement and another table that is not included in the
Flashback Database provides:
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .
Write For Us