Tablespace Datafile wise free space:

Tablespace Datafile wise free space:

set lines 152

col TABLESPACE format a10

col FILE_NAME format a35

col BYTES format format a10

col MAXBYTES format a12

col AUT format a8

col STATUS format a12

select TABLESPACE_NAME,FILE_NAME,bytes/1024/1024,maxbytes/1024/1024,autoextensible,status from dba_data_files;