How can I drop a datafile in NOARCHIVELOG mode

[edwtsang]

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?

[kgb]

http://www.dbasupport.com/forums/sho...threadid=12036