Re: Database file deleted !!!

From: Manoj Appully <manoj.appully_at_bridge.bellsouth.com>
Date: 1997/09/22
Message-ID: <3426E675.4B2F@bridge.bellsouth.com>#1/1

Paul.deAnguera_at_ci.seattle.wa.us wrote:

   Jan Kopinec <kopinec_at_ips-ag.ch> writes:

      Please does anybody knows the soultion:

  On our ORACLE NT7.3 when the database
  was done the almoust empty database file was deleted but we did   forget to delete its tablespace like the first. Is here any way how   to start-up (open) the database and at least export the data   out!  

 Try startup mount and alter the tablespace to have a new file. If that works, drop the tablespace; then you
 can remove the file. Good luck!  

• Paul de Anguera, ESD/HRIS, City of Seattle

  ---

Try this

from sqldba,
startup mount;
alter database datafile 'datafile spec' offline drop; alter database open;

Manoj Appully Received on Mon Sep 22 1997 - 00:00:00 CDT