| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> ************Urgent Help me !!!**************
Dear All,
In one of database the developer had deleted a table and
commited it.
database is in online backup but no export backup or table backup
Please tell me how can I recover the the table .
please guide me the exact detailed ed steps to recover the table .
We have online backup .Archive log mode.
We don`t have coldbackup.!!!
I tried with shutdown the database.
Strtup mount
recover database until time '2001-02-09:22:00:00';
media recovery completed.
alter database open
it says noresetlogs or resetlogs.
I tried with norestelog then no data found i that table.
after that I tried with resetlogs.
still then no rows select from that table.
send me the possible way to recover the table.please send me thesteps to be done to recover the table.
Regards,
Saroj.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dash, Saroj (CAP,CEF)
INET: Saroj.Dash_at_gecapital.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Feb 13 2001 - 06:46:51 CST
 |
 |