Dropping a Datafile From a Tablespace

How To

You can drop a datafile file from a tablespace when it is no longer required. To drop a datafile from a tablespace the datafile must be empty and the datafile cannot be the only one left in the tablespace. The datafiles in the system and default tablespaces cannot be dropped.