-
Please help!
I have deleted a physical datafile space on Unix box before dropping the tablespace in Oracle. After the fact, when I try to drop Oracle tablespace the Instance crashed. I started the instance in mount mode, try to alter the tablespace offline Oracle tell me db is not open. I then tried to alter db open, I receive error 01157 cannot identify/lock datafile and ora 01110 datafile /oracle/----/----/ datafile"name".
How do I recover Oracle without having to do a backup of the datafile? This datafile has no useful purpose.
Is their a way to recover form this?
THanks
Dev
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|