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 Wed Jul 15 1998 - 07:26:22 CDT
