Re: Accidently deleted tablespace data file

"matt goyer" <207erb_at_sympatico.ca> wrote in message news:<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,
> Matt
>
> SQL> drop tablespace [tablespacename] including contents;
> drop tablespace [tablespacename] including contents
> *
> 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

Make it offline first.
HTH
Tho Nguyen Received on Fri Mar 08 2002 - 04:08:15 CET