ALTER tablespace GAP ADD datafile '/ora_data1/ecvdbsvr/gaptbspace7.dbf' SIZE 1024M;
SELECT file_name, bytes, autoextentible FROM dba_data_files;

ALTER tablespace ADD temp file '/u01/data/xxxx.dbf' size 1024M
    autoextend no extent management LOCAL;
SELECT file_name, bytes, autoextentible FROM dba_temp_files;

ALTER DATABASE datafile 'c:\oracle\oradata\orabase\tools02.tom' RESIZE 50M;
ALTER DATABASE tempfile '/osysdb/xpc8db/temp04.dbf' resize 2048M;

SET linesize 100;
SET pagesize 100;
 
COLUMN file_name format a40;
COLUMN tablespace_name format a10;
SELECT FILE_NAME,TABLESPACE_NAME,BYTES,AUTOEXTENSIBLE,
       MAXBYTES,INCREMENT_BY FROM DBA_DATA_FILES ORDER BY TABLESPACE_NAME;