Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ORA-1033 Error (Advanced Question)

Status
Not open for further replies.

acct98

IS-IT--Management
Aug 15, 2002
194
US
This one will make you laugh and me cry! Well lets begin -
I am now receiving and ORA-1033 Error. I know why this is happening. This is because I can connect to the database which is on an external drive. Anyway here is where it gets interesting -- I physically dropped the hard drive. Unfortunately I cant access the database (no backup). I can receate the database if I could get access the system.
My questions are:
1-How do I get access to the system?
2-How do I recreate the control files to configure oracle to look at another database which is on my c: drive?


Any help would be greatly appreciated?

 
If you have another database on your c: drive then you only need to change ORACLE_SID to access it or am I missing something ?

Alex
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top