SELECT FILE_NAME,TABLESPACE_NAME,BYTES/1024/1024 MB,AUTOEXTENSIBLE,
MAXBYTES/1024/1024 MAX_MB
FROM DBA_DATA_FILES
where tablespace_name='&TABLESPACE';