Regarding the backup [message #70525] |
Tue, 25 June 2002 08:14 |
yram
Messages: 75 Registered: February 2001
|
Member |
|
|
hello
I hve a closed backup of my database , i have inserted 10 rows for the table emp , so i have 24 rows know, the backup has 14 rows,
and accidently i have delted my emp table , can i retreive the table called emp,
do help me.
yram
|
|
|
Re: Regarding the backup [message #70528 is a reply to message #70525] |
Tue, 25 June 2002 10:40 |
Andrew
Messages: 144 Registered: March 1999
|
Senior Member |
|
|
The answer is: there is a 90% you can get your table back.
The configuration of your database will determine how you will do it.
If you are in archive log mode, you can restore from your backup, then recover the database using the archive logs.
If you are in no archive log mode, you might still be able to restore the datafiles, and recover the database using the information from the online redo logs, IF the information is still there.
So, the only way you will completely lose the table is if the database is not in archive log mode, and the redo logs have switched out enough so that the information is no longer there (and, of course, not archived.)
Andrew
|
|
|