Some plonker typed rm temp.dbf AAARRGGHHH!

Hi,

try the following:

connect as internal in Server Manager or SQL*DBA. Ignore the 'cannot open database'-error, and type
"alter database datafile <path>/temp.dbf offline drop;". Now shutdown and startup, and drop the tablespace. This should solve it!

Bas

> -----Original Message-----
> From: welfers_at_my-dejanews.com [SMTP:welfers_at_my-dejanews.com]
> Posted At: Wednesday, July 15, 1998 2:26 PM
> Posted To: server
> Conversation: Some plonker typed rm temp.dbf AAARRGGHHH!
> Subject: Some plonker typed rm temp.dbf AAARRGGHHH!
>
> A colleague decided to clear some space from a filesystem and deleted
> a dbf
> file. Not surprisingly oracle is bleating about it. How do I fix it?
> Fortunately the dbf was for temp tables and as far as I can make out
> nothing
> was using it anyway. I tried to drop the tablespace but oracle
> complained
> that it could not find the datafiles. I know how to create and drop
> tablespaces etc but I would have thought the first job would be to
> tell
> oracle that the temporary tablespace no longer exists before adding it
> again.
> Before you ask the answer is "no we don't have any backups or archive
> logs or
> exports." :(( Not my fault honest I did not know the machine existed
> until
> yesterday when I heard about the problem. It is my job to fix it so
> any help
> would be appreciated. Thanks in advance.
>
> -----== Posted via Deja News, The Leader in Internet Discussion
> ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member
> Forum
Received on Fri Jul 17 1998 - 13:00:44 CDT