Re: Deleted datafile

In <3261f2b6.258541927_at_news.eunet.no>, ahy_at_haaix04.allianse.no (Arild Hystad) writes:
>I hav accidentally deleted a datafile in Oracle 7.0.16 for HP-UX. Now
>I can't drop the tablespace which was connected to that datafile. Is
>there a way to remove a tablespace when ethe datafile is missing?

sqldba> startup nomount;
sqldba> alter database datafile '/orapath/files/deletedFile.dbf' offline drop;
sqldba> alter database open;
sqldba> drop tablespace TStoDrop;

M.Landa Received on Mon Oct 14 1996 - 00:00:00 CEST