RE: ora-01113 and ora-01110

If that's all you have done, I don't think you need media recovery. All you need to do is to relink the data file.

Zhong
It's another beautiful day!

-----Original Message-----
From: achoto_at_american.edu [mailto:achoto_at_american.edu] Sent: Monday, July 10, 2000 2:21 PM
To: Multiple recipients of list ORACLE-L Subject: ora-01113 and ora-01110

I need some help. I deleted a datafile by mistake. I need to recover it. The datafile is still there and offline. I get the error

ora-01113 and ora-01110. Indicating I need to do a media recovery. I've never done this and I'm not sure what do I need to do.

Can someone out there help me with some pointers to recover it?

Thanks

Ana E. Choto
Systems Programmer
American University
Office of Information Technology
Phone (202) 885-2275
Fax (202) 885-2224

-- 
Author: 
  INET: achoto_at_american.edu

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).