Oracle Storage in Action: deleting physical data files

ALTER tablespace xh_dm DROP datafile ' F:\DEV\ORACLE-DATA\ORCL\XH_DM_1.DBF ';

sql> ALTER tablespace XH_DM
2 DROP datafile ' F:\DEV\ORACLE-DATA\ORCL\XH_DM_1.DBF ';
ALTER tablespace XH_DM
*
ERROR at line 1:
Ora-03262:the file is Non-empty

1 --Oracle Storage Deletes an invalid data file, and the above invalid table2 --1. View the file ID3 Select file_id,file_name, Tablespace_name fromDba_data_filesOrder  by file_id;4 5 6 --2. G Find the segment, table, partition name stored on the file based on ID7 SelectOwner,segment_name,file_id  fromDba_extentswhere file_id=9;8 9 Ten --3. Completely delete the table, if the table content is valid, first move the table to other tablespace e.g. ALTER table Sql_log move tablespace USERS; One Drop TableTemp_user_extent purge; A Drop Tabletemp_user_segments purge; - Drop TableSql_log purge; -  the  - --4. Delete data Files - ALTERTablespace XH_DMDROPDataFile'F:\DEV\ORACLE-DATA\ORCL\XH_DM_1.DBF';

Tablespace altered.

Oracle Storage in Action: deleting physical data files