查看表空间
select name from v$tablespace;
创建表空间
create tablespace data01
datafile 'D:\app\data01.dbf'
size 100m;
改变表空间状态
alter tablespace data01 online;
重命名表空间
alter tablespace data01 rename to data02;
改变表空间中的数据文件的大小
select tablespace_name,bytes,blocks from dba_free_space
where tablespace_name='DATA02';
select tablespace_name, file_name, bytes
from dba_data_files
where tablespace_name='DATA02';
alter tablespace data02
add datafile 'D\app\data01.dbf'
size 100m;
alter database
datafile 'D:\app\data01.dbf'
autoextend on next 10m maxsize unlimited;
移动表空间的数据文件
alter tablespace data02 offline;
alter tablespace data02
rename datafile 'D:\app\data02.dbf' to 'd:data02.dbf';
删除表空间
drop tablespace data02 including contents and datafiles;