Restore Oracle 9i DBF files into Windows XP server [message #159860] |
Tue, 21 February 2006 23:25 |
lwee
Messages: 2 Registered: February 2006 Location: SIngapore
|
Junior Member |
|
|
Dear database experts out there,
Not sure if this topic has been discussed before but I dont seem to be able to locate any when i perform a search.
Can any experts kindly guide me on the followings:
1) I have just installed Oracle 9i ver 9.2.0 into a Window XP Server. Everything went smoothly so this is not an issue. The controlfiles, redo files, system01.dbf etc were created.
2) I have to restore the DBF files into the new database, how am i going to restore the data to the database? Can anyone show me the process?
3) Actually the DBF files were copied from another XP server. I have stopped the Oracle services and zip up the file and move it to the new XP server. (is this the right way?)
I'm kinda stuck here so would really appreciate some form of help here. Many Thanks.
wee
|
|
|
|