set lines 1000
set pages 2000
col tablespace_name for a24
col name for a60
col Total(Mb) for a20
col status1 for a7
col status2 for a7
col status3 for a9
col online_status for a10
col st_backup for a10
col recover for a7
col error for a10
col "FILE#" for 9999
SELECT	df.tablespace_name,
	d.FILE#,
	d.NAME,
	df.autoextensible,
	to_char(round(df.bytes/1024/1024,0),99999999.99) "Total(Mb)",
	d.status   VDTFILE,
	df.STATUS  DDTFILE,
	dh.status  HDTFILE,
	--df.online_status,
	b.STATUS st_backup,
	dh.RECOVER
	--dh.ERROR
from v$datafile d,
	 dba_data_files df,	
	 v$backup b,
	 v$datafile_header dh
where	
	d.FILE# = dh.FILE#(+)
	and    	d.FILE# = b.FILE#(+)
	and    	d.FILE# = df.file_id(+)
	order by df.tablespace_name, d.NAME;
	and     df.tablespace_name LIKE '&APPS_TS_TX_IDX';
	
alter database datafile [datafile] resize 4000m;