Snippet Name: FLASHBACK: Syntax Elements
Description: In Oracle databases, Flashback tools allow administrators and users to view and manipulate past states of an instance's data without (destructively) recovering to a fixed point in time.
Also see: » FLASHBACK: Oracle 10G enhancements
» FLASHBACK: AS OF clause
» FLASHBACK: SYS commands and queries
» FLASHBACK: Initialization Parameters
Comment: (none)
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 13th, 2009
|
Turning flashback off AND ON -
ALTER database flashback off;
ALTER database flashback ON;
--------------------------------
SET Retention Target IN minutes
ALTER system SET DB_FLASHBACK_RETENTION_TARGET = 2880;
START flashback ON a tablespace
ALTER tablespace tblspc_test flashback ON;
Stop flashback ON a tablespace
ALTER TABLESPACE <tablespace_name> FLASHBACK OFF;
ALTER tablespace tblspc_test flashback off;
|