sql> ALTER DATABASE datafile '/U01/APP/ORACLE/ORADATA/KING/SYSAUX01.DBF ' resize 2048M;
Database altered.
sql> ALTER DATABASE datafile '/U01/APP/ORACLE/ORADATA/KING/SYSTEM01.DBF ' resize 2048M;
Database altered.
sql> ALTER DATABASE tempfile '/U01/APP/ORACLE/ORADATA/KING/TEMP01.DBF ' resize 2048M;
Database altered.
sql> ALTER DATABASE datafile '/U01/APP/ORACLE/ORADATA/KING/UNDOTBS01.DBF ' resize 2048M;
Database altered.
sql> ALTER DATABASE datafile '/U01/APP/ORACLE/ORADATA/KING/USERS01.DBF ' resize 2048M;
Database altered.
sql> ALTER DATABASE datafile '/U01/APP/ORACLE/ORADATA/KING/SYSAUX01.DBF ' autoextend off;
Database altered.
sql> ALTER DATABASE datafile '/U01/APP/ORACLE/ORADATA/KING/SYSTEM01.DBF ' autoextend off;
Database altered.
sql> ALTER DATABASE Tempfile '/U01/APP/ORACLE/ORADATA/KING/TEMP01.DBF ' autoextend off;
Database altered.
sql> ALTER DATABASE datafile '/U01/APP/ORACLE/ORADATA/KING/UNDOTBS01.DBF ' autoextend off;
Database altered.
sql> ALTER DATABASE datafile '/U01/APP/ORACLE/ORADATA/KING/USERS01.DBF ' autoextend off;
Database altered.
CREATE TABLE Space
sql> Create Tablespace TPCC
DataFile '/u01/app/oracle/oradata/king/tpcc01.dbf '
Size 1024M
Extent Management Local
Uniform size 1M;
Tablespace created.
adding tablespace data files
Sql> Alter Tablespace TPCC
Add datafile '/u01/app/oracle/oradata/king/tpcc02.dbf '
Size 1024M;
Tablespace altered.
Move a tablespace data file
sql> alter tablespace TPCC01 offline;
Tablespace altered.
Sql> Host Cp/u01/app/oracle/oradata/king/tpcc02.dbf/u02/app/oracle/oradata/king
Sql> Alter Tablespace TPCC01
Rename datafile '/u01/app/oracle/oradata/king/tpcc02.dbf '
To '/u02/app/oracle/oradata/king/tpcc02.dbf ';
Tablespace altered.
sql> alter tablespace TPCC01 online;
Tablespace altered.
Sql> Host RM-RF/U01/APP/ORACLE/ORADATA/KING/TPCC02.DBF
Delete Table space
Sql> drop tablespace tpcc01 including contents and datafiles;
Tablespace dropped.
Oracle Database 11G R2 table space Management