salam 3alekom

a big problem happened to me and please help

i installed Oracle database 10gR1 on windows and once the OS FAILED

SO WHAT IS THE SOLUTION WITH THE SCHEMA I HAVE CREATED AND ITS MY Project
please help

note:Oracle database was installed on a partion rather than that of the windows

Thanks

Dear Nasser..

As I understood from your problem that it is a OS problem.. So you need to reinstall windows..
If this is the case.. This is the easist way to recover the problem
First take backup of your oracle datafiles including the control files.
Install your operating system
install oracle software.
create oracle database instance as the same as your orginal old database and the same file locations.
Shut down the database
restore your data files and the control files from the backup taken previously
start the database

This should work.
please try it and inform us about the resul

t

Thanks so Much
could you please inform me with the way i restore with it the Database with any documents or with explanation

What I mean by restore is to copy your orginal data files back to the old location .. It is the normal os copy procedure
but please make sure that your database is not started