In svrmgr, issue the : alter database datafile file_name offline drop; sql
commands to
drop the datafile. you can use either startup nomount or startup force in
svrmgr to startup oracle.
Jean-Francois Vincent wrote in message <35DAE10E.1F37_at_platinum.com>...
>Hi, a .dbf file of a tablespace was erased and now the instance doesn't
>want to start and stay started but not opened, so we can't drop the
>tablespace with the command DROP TABLESPACE INCLUDING CONTENTS in the
>svrmgr. How to delete the tablespace and restore the rest of the
>instance ?
>
>
>thank. J-Fr.
Received on Wed Aug 19 1998 - 10:13:35 CDT
