Cannot delete a tablespace's datafile

From: Huy Vu <huyv_at_usa.net>
Date: Tue, 06 Mar 2001 05:32:57 GMT
Message-ID: <983856777.649868@news.aei.ca>

Hi all,

I tried to delete a datafile1.dbf of tablespace A with the command:

svrmgrl> connect internal
> startup mount ORCL
> alter database datafile '/u01/oradata/ORCL/datafile1.dbf' offline drop;

Statement successful

rm /u01/oradata/ORCL/datafile1.dbf

and then

> alter database open;

but the database ORCL still remember the '/u01/oradata/ORCL/datafile1.dbf of tablespace A and displayed the error message about this datafile 'datafile1.dbf' not found. The tablespace A cannot online eventhough other datafiles in this tablespace can turn to online.

What is the right command to drop a datafile of a tablespace?

Thanks in advance for any help.

DH. Received on Mon Mar 05 2001 - 23:32:57 CST