Accidently deleted tablespace data file
From: matt goyer <207erb_at_sympatico.ca>
Date: Thu, 7 Mar 2002 17:24:26 -0500
Message-ID: <vNRh8.108100$JZ.14277083_at_news20.bellglobal.com>
Date: Thu, 7 Mar 2002 17:24:26 -0500
Message-ID: <vNRh8.108100$JZ.14277083_at_news20.bellglobal.com>
I accidently deleted one of my tablespace data files which isn't a big deal
since it's a development database but now I can't drop the tablespace. How
do I force Oracle to drop this tablespace? Or how do I manually drop it?
Thanks,
SQL> drop tablespace [tablespacename] including contents;
drop tablespace [tablespacename] including contents
*
Matt
ERROR at line 1:
ORA-01116: error in opening database file 2
ORA-01110: data file 2: '/home/mgoyer/data1'
ORA-27041: unable to open file
SVR4 Error: 2: No such file or directory
Additional information: 3
Received on Thu Mar 07 2002 - 23:24:26 CET