Скачать или смотреть TABLESPACE MANAGEMENT CREATE TABLESPACE ALTER DATAFILE

How to check existing tablespace information in database
=========================================================
select tablespace_name from dba_tablespaces;

How to create a tablespace
===============================
create tablespace king datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING01.DBF' size 10m;

How to Resize the datafile
==========================
alter database datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING01.DBF' resize 20m;

Adding a datafile to a tablespace
=================================
alter tablespace king add datafile 'E:\DATABASE\DATABASE\ORADATA\ORCL\KING02.DBF' size 10m;



How to get the defintion of tablespace
======================================
set head off echo off
select 'select dbms_metadata.get_ddl(''TABLESPACE'','''
|| tablespace_name || ''') from dual;' from dba_tablespaces;