{{adsense}}
{{parent page="Oracle"}}

=== Adding datafile to existing tablespace ===
%%(sql)
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;
%%

=== Resize existing datafile ===
%%(sql)
alter database datafile 'c:\oracle\oradata\orabase\tools02.tom' RESIZE 50M;
alter database tempfile '/osysdb/xpc8db/temp04.dbf' resize 2048M;
%%

=== Listing datafiles in a tablespace ===
%%(sql)
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;
%%