SYS@orcl> select file_name,tablespace_name,bytes/1024/1024,autoextensible from dba_data_files order by 3;
FILE_NAME TABLESPACE_NAME BYTES/1024/1024 AUT
-------------------------------------------------- ------------------------------ --------------- ---
/u01/app/oracle/oradata/ORCL/users01.dbf USERS 5 YES
/u01/app/oracle/oradata/ORCL/undotbs01.dbf UNDOTBS1 630 YES
/u01/app/oracle/oradata/ORCL/sysaux01.dbf SYSAUX 810 YES
/u01/app/oracle/oradata/ORCL/system01.dbf SYSTEM 3850 YES
SYS@orcl> alter tablespace users add datafile '/u01/app/oracle/oradata/ORCL/users02.dbf' size 20m autoextend on;
Tablespace altered.
SYS@orcl> select file_id,file_name,tablespace_name,bytes/1024/1024,autoextensible from dba_data_files order by 4;
FILE_ID FILE_NAME TABLESPACE_NAME BYTES/1024/1024 AUT
---------- -------------------------------------------------- ------------------------------ --------------- ---
7 /u01/app/oracle/oradata/ORCL/users01.dbf USERS 5 YES
5 /u01/app/oracle/oradata/ORCL/users02.dbf USERS 20 YES
4 /u01/app/oracle/oradata/ORCL/undotbs01.dbf UNDOTBS1 630 YES
3 /u01/app/oracle/oradata/ORCL/sysaux01.dbf SYSAUX 820 YES
1 /u01/app/oracle/oradata/ORCL/system01.dbf SYSTEM 3850 YES
