| recovery of drop table [message #282805] |
Fri, 23 November 2007 10:46  |
geetu_gaur
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)
regards
geetu
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  |
 |
Mahesh Rajendran
Messages: 10707
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
