Hi

the only way to drop a datafile from a tablespace with 2 or more datafiles is export the contents in tablespace, drop the tablespace and create a new tablespace and import the data. Remember add a datafile is simple, to delete one is pretty complex!