To drop a datafile from a tablespace
Select the tablespace you want to modify from the tree or the tablespaces page. The Properties page is displayed.
Select the datafile that you want to remove from the tablespace.
NOTE You cannot remove a datafile from a tablespace if it is the only datafile remaining in the tablespace.
Click the Drop File button.
NOTE You cannot not drop the system or default tablespace datafiles.
Related topic: