User Tools

Site Tools


oracle:howto_database

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

oracle:howto_database [2020/04/07 11:00] (current)
dodger created
Line 1: Line 1:
 +====== [HOWTO] Flashback Database ======
 +
 +
 +<code sql>
 +CREATE RESTORE POINT CORRUPTION_KILLER ;
 +col scn format 999999999999999
 +SELECT NAME, SCN, TIME, DATABASE_INCARNATION#,​
 +        GUARANTEE_FLASHBACK_DATABASE,​STORAGE_SIZE
 +        FROM V$RESTORE_POINT;​
 +</​code>​
  
oracle/howto_database.txt ยท Last modified: 2020/04/07 11:00 by dodger