sonia is correct the only way to drop a datafile from db w/o dropping the ts is to offline drop it provided it is not the last file in the ts . it will not force you to drop the ts . This will also remove the entry from the data dictionary.