CoderZone.org

Category: >> Oracle PL/SQL >> FLASHBACK: Syntax Elements Bookmark and Share

<< lastnext >>

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 Paramete...

Comment: (none)

Author: CoderZone
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; 
 
 
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© coderzone.org | users online: 6