Home » RDBMS Server » Performance Tuning » recovery of drop table (oracle9i)
recovery of drop table [message #282805] Fri, 23 November 2007 10:46 Go to next message
Messages: 1
Registered: November 2007
Junior Member
hi all

when we drop a table then we can recover the table using incomplete recovery on immediately bases. i want to know from where data comes when we will recover the table(means when data goes when we drop a table, like data goes in redo buffer when we delete the data)

plz mail me reply on riya.arora03@gmail.com
Re: recovery of drop table [message #282820 is a reply to message #282805] Fri, 23 November 2007 18:06 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Delete or Drop, data comes from your redo log files.
All activities are written to redo log files (from redo buffer) in a cyclic fashion. If you have enabled archive logging, information from redo logs will be archived to another file (archive log file) before it is overwritten.
Previous Topic: SHARED POOL contents
Next Topic: advantages and disadvantages of optimization
Goto Forum:

Current Time: Sun Oct 23 02:07:44 CDT 2016

Total time taken to generate the page: 0.12837 seconds