datafile_resize.sql

set pagesize 1000
set linesize 9999
col file_name for a60
col tablespace_name for a20

select file_name,bytes/1024/1024/1024 gb,AUTOEXTENSIBLE,INCREMENT_BY INC,MAXBYTES/1024/1024/1024 MAX_GB_CAN_EXTEND from dba_data_files where TABLESPACE_NAME='&TBS_NAME';

-------------------------

alter database datafile '/oracle/data1/database_name/file_name01.dbf' resize 10g
alter database datafile '/oracle/data1/database_name/file_name01.dbf' AUTOEXTEND ON NEXT 10g MAXSIZE 10g;
-----------------------