10:02:22 SQL> col file_name for a50
10:02:42 SQL> select file_id,tablespace_name,file_name,bytes/1024/1024/1024 G from dba_data_files where tablespace_name='&ts' order by 1;
Enter value for ts: TBS_LOGIDX
old 1: select file_id,tablespace_name,file_name,bytes/1024/1024/1024 G from dba_data_files where tablespace_name='&ts' order by 1
new 1: select file_id,tablespace_name,file_name,bytes/1024/1024/1024 G from dba_data_files where tablespace_name='TBS_LOGIDX' order by 1
FILE_ID TABLESPACE_NAME FILE_NAME G
---------- ----------------------- -------------------------------------------------- ----------
2 TBS_LOGIDX /u01/app/oracle/oradata/DLOG/tbs_logix01.dbf 31.9999847
18 TBS_LOGIDX /u01/app/oracle/oradata/DLOG/tbs_logix02.dbf 31.9570313
19 TBS_LOGIDX /u01/app/oracle/oradata/DLOG/
tbs_unvidx03.dbf
31.9570313
3 rows selected.
Elapsed: 00:00:00.01