Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Oracle Flashback Query (Read 5372 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Oracle Flashback Query
13.10.07 at 12:11:55
 
Oracle Flashback Query
 
Oracle flashback quries can show the state of data at a point in time in the past without requiring any structural changes to the database. Using Flashback Query, users can execute queries against a snapshot of data consistent to a point in time in the past.
 
Recovering Accidentally Deleted Data
INSERT[ INTO mytable
(  SELECT *  
   FROM   mytable
   AS OF TIMESTAMP trunc(sysdate)
   MINUS
   SELECT *  
   FROM mytable
);

http://www.oracle.com/technology/deploy/availability/htdocs/Flashback_Overview.h tm
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Oracle Flashback Query
Reply #1 - 23.11.07 at 10:32:06
 
If you don't want changes to go into the recycle bin you can use the purge keyword.
 
For example: drop table mytable purge;
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Oracle Flashback Query
Reply #2 - 20.12.07 at 13:29:02
 
To empty the recycle bin you can run the following command to empty the user's recycle bin:
 
purge recyclebin;
 
To empty the DBA recycle bin run:
 
purge dba_recyclebin;
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1