Solution to Oracle Tablespace not enough

Execute the following commands by using SYSTEM account login Oracle:

　　>sqlplus System/[email Protected]:1522/xe;

Sql*plus:release 12.1.0.1.0 Production on Tue Sep 22 20:16:29 2015

Copyright (c) 1982, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0-64bit Production

Sql>

1.the below command to display thecurrent size of tablespace

> Select T.tablespace_name,round (SUM ( Bytes/(1024*1024)), 0) ts_size from dba_tablespaces t,dba_data_files D where t.tablespace_name=d.tablespace_name  Group by T.tablespace_name;

tablespace_name           ts_size
------------------- ---------------------
undotbs1                   510


SQL>

2.use the below command to display the path of tablespace that would be used in command to modify the size of tablespace.

>Select File_name,tablespace_name from Dba_data_files;

file_name tablespace_name
------------------------------------------------------------------------------------------------------- -------
/u01/app/oracle/oradata/xe/system.dbf System

3.the Last command was to expand the size of current tablespace.
> ALTER DATABASE datafile '/U01/APP/ORACLE/ORADATA/XE/SYSTEM.DBF ' resize 5600M;

Database altered.

Sql>

Solution to Oracle Tablespace not enough