Oracle删除数据文件

SQL> select file_name,file_id from dba_data_files where tablespace_name='TEST';

FILE_NAME                         FILE_ID
------------------------------ ----------
/oradata/june/test.dbf                  6
/oradata/june/test1.dbf                 9
/oradata/june/test2.dbf                10

SQL> select distinct owner,segment_name from dba_Extents where FILE_ID=6;

OWNER                          SEGMENT_NAME
------------------------------ --------------------
TEST                           EMPLOYEES
TEST                           ORDERS
TEST                           BFW_TEST
TEST                           B1
TEST                           STRACE
TEST                           T1
TEST                           TEST
TEST                           SYS_C0011275
TEST                           TEST2
TEST                           A2
TEST                           HOTEL

OWNER                          SEGMENT_NAME
-------------------------