| recovering dropped table [message #69837] |
Tue, 12 March 2002 23:52  |
krishna
Messages: 141
Registered: October 1998
|
Senior Member |
|
|
User Hari creates a table t1, inserts data into it.
Now internal issues the command
alter system switch logfile;
Hari then drops this table.
Later Hari discovers he wants this table back. How does he go about retrieving the table?
Does 'recover database until time......' do the trick?
|
|
|
|
| Re: recovering dropped table [message #69843 is a reply to message #69837] |
Wed, 13 March 2002 08:03  |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
If your logs have not cycled through and overwritten the data you can. You would restore your data file, not your logs and it will roll forward to a point in time. Good reason to archive your logs.
You can also use logminer.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
