Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Recovering the Data from DBF files
Why not simply open the database and use export utility?
You only need the same Oracle version installed on a machine with the same
operating system, put the database files, redolog files, controlfiles on it
and start the db. Should work.
Maybe "alter database rename datafile" is needed when files are in other
directories.
Young <uylee_at_madco911.com> schreef in berichtnieuws
uomi89t176a9bd_at_corp.supernews.com...
| Recently our database server(with Oracle8i) crashed due to the harddrive
| failure.
| Fortunately the harddrive was not badly damaged and we were able to
recover
| all the oracle related files including all the DBF.
| But here is the problem. We need to somehow export the data from DBF files
| then import them into new DB.
| Is it possible to extract the data from those DBF files?
| Or is there any other method to retrieve them?
| Your assistance will be greatly appreciated.
|
|
Received on Fri Sep 20 2002 - 14:51:43 CDT