asked on

How to reload a schema from Oracle DBF file only?

I was running Oracle 10g when my PC crashed. I have reinstalled Windows XP on C Drive. My Oracle installation, DBF files, CTL files are all intact in Drive D. Now I want to reinstall Oracle & use the same DB schemas? I need to know the steps to use the same old schemas which I created in the original DB.

ASKER CERTIFIED SOLUTION

airtifa

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Mub123

ASKER

thanks airtifa.

The problem with your suggestion is that Oracle does not allow me to install again on the same folder. My original folder was D:\oracle\product\10.2.0\db_1. I tried to install Oracle again on this folder, but it does not allow this action. Need to know how to install oracle on the same location again.

airtifa

you have to copy all datafiles,controlfiles,redolog files,password file,spfile from the old database and then remove the old oracle directory then begin steps I told you in my last reply

airtifa

you have to copy all datafiles,controlfiles,redolog files,password file,spfile from the old database and then remove the old oracle directory then begin steps I told you in my last reply

airtifa

you have to copy all datafiles,controlfiles,redolog files,password file,spfile from the old database and then remove the old oracle directory then begin steps I told you in my last reply

KICUSek

I assume You have admin rights.
Delete all registry keys beginning with Oracle in placed in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services.
Restart server, delete Oracle software (also found in Program Files).
Delete registry key: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE.
Then, You should be able to reinstall Oracle software.