Quick Search:
 
 Oracle PL/SQL: FLASHBACK: Initialization Parameters Jump to:  
Category: >> Oracle PL/SQL >> FLASHBACK: Initialization Parameters  

<< lastnext >>

Snippet Name: FLASHBACK: Initialization Parameters

Description: Setting the location and size of flashback recovery area.

The Flashback Data Archive can be used to automatically track and maintain historical changes to all Oracle data in a highly application transparent, secure and efficient manner. Flashback query allows a user to view the data quickly and easily the way it was at a particular time in the past, even when it is modified and committed, be it a single row or the whole table.

Also see:
» FLASHBACK: Oracle 10G enhancements
» FLASHBACK: AS OF clause
» FLASHBACK: SYS commands and queries
» FLASHBACK: Syntax Elements

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 13th, 2009

Initialization Parameters 
 
Setting the location OF the flashback 
recovery area db_recovery_file_dest=/oracle/flash_recovery_area 
 
 
Setting the size OF the flashback 
recovery area db_recovery_file_dest_size=2147483648 
 
Setting the retention TIME FOR flashback files (IN minutes)
-- 2 days
db_flashback_retention_target=2880 
 


 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org