SQL> select file_name, file_id, tablespace_name, status
  2  from dba_data_files 
  3  order by tablespace_name;

FILE_NAME                                                 FILE_ID TABLESPACE_NAME    STATUS
--------------------------------------------------------- ------- ------------------ ---------
/VOL03/oradata/abc/ndex/ctm_idx_lrg31.dbf                     389 CTM_IDX_LRG        AVAILABLE
MISSING0466 **                                                466 CTM_IDX_LRG        AVAILABLE
/VOL03/oradata/abc/ndex/ctm_idx_lrg32.dbf                     409 CTM_IDX_LRG        AVAILABLE
...
/VOL02/oradata/abc/data/tas_data_lrg40.dbf                    470 TAS_DATA_LRG       AVAILABLE
MISSING0467 **                                                467 TAS_DATA_LRG       AVAILABLE
/VOL02/oradata/abc/data/tas_data_lrg15.dbf                    237 TAS_DATA_LRG       AVAILABLE

SQL> select FILE_NAME, TABLESPACE_NAME, STATUS
  2  from DBA_DATA_FILES
  3  where FILE_NAME like 'MISSING0467';

FILE_NAME                                                    TABLESPACE_NAME                STATUS
------------------------------------------------------------ ------------------------------ ---------
MISSING0467                                                  TAS_DATA_LRG                   AVAILABLE

SQL> select FILE_NAME, TABLESPACE_NAME, STATUS
  2  from DBA_DATA_FILES
  3  where FILE_NAME like 'MISSING0466';

FILE_NAME                                                    TABLESPACE_NAME                STATUS
------------------------------------------------------------ ------------------------------ ---------
MISSING0466                                                  CTM_IDX_LRG                    AVAILABLE