Hi there,

I want to drop 2 extra datafiles that just added to a tablespace.

I used 'ALTER DATABASE DATAFILE OFFLINE DROP';

When I restart the database, V$DATAFILE status became RECOVER. However, I can startup the database properly.

How can I remove the datafile permanently in V$DATAFILE?