SQL> select name from v$tablespace;
NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
USERS
TEMP
EXAMPLE
ARTMPSPC
ARSYSTEM
ARTMPNGETM
ARNGETM
************************************************************************************************************************
SQL> select tablespace_name,file_name,bytes/1024/1024 from dba_data_files; (This is for permanent/undo tablespace)
TABLESPACE_NAME
------------------------------
FILE_NAME
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
BYTES/1024/1024
---------------
USERS
/u01/app/oracle/oradata/orcl/users01.dbf
5
UNDOTBS1
/u01/app/oracle/oradata/orcl/undotbs01.dbf
4955
SYSAUX
/u01/app/oracle/oradata/orcl/sysaux01.dbf
SQL> alter tablespace ARNGETM add datafile '/u01/app/oracle/oradata/orcl/ARdfngetm1.dbf' size 10G;
Tablespace altered.
SQL> alter database datafile'/u01/app/oracle/oradata/orcl/ARdfngetm1.dbf' AUTOEXTEND ON;
Database altered.
*************************************************************************************************************************
SQL> select tablespace_name,file_name,bytes/1024/1024 from dba_temp_files; (This method is apply for temporary tablespace)
TABLESPACE_NAME FILE_NAME BYTES/1024/1024
TEMP /u01/app/oracle/oradata/orcl/temp01.dbf 1024
ARTMPSPC /u01/app/oracle/oradata/orcl/artmp 1527
ARTMPNGETM /u01/app/oracle/oradata/orcl/artmpdfngetm 10240
SQL> alter database tempfile '/u01/app/oracle/oradata/orcl/artmp' resize 16G;