查看所的表空间及未使用情况
select sum(bytes)/(1024*1024*1024) as free_space,tablespace_name from dba_free_space group by tablespace_name;
单个表空间未使用情况
select sum(nvl(a.bytes,0))/1024/1024/1024 as 未使用G from dba_free_space a where a.tablespace_name=' 表空间名称 ';
增加表空间文件(相应的文件空间就减少了)
alter tablespace 表空间名称 add datafile '/oracle/oradata/BillSysData/datafile/datafile002' size 10g ;
创建表空间
create tablespace 表空间名称 logging datafile 'D:\oracle\product\10.2.0\oradata\itmc\itmc.dbf' size 500m autoextend on next 50m maxsize 10240m extent management local;
创建临时表空间
create temporary tablespace itmctemp tempfile 'D:\oracle\product\10.2.0\oradata\itmc\itmctemp.dbf' size 500m autoextend on next 50m maxsize 1024m extent management local;
删除表空间
DROP TABLESPACE 表空间名称 INCLUDING CONTENTS AND DATAFILES;
select sum(bytes)/(1024*1024*1024) as free_space,tablespace_name from dba_free_space group by tablespace_name;
单个表空间未使用情况
select sum(nvl(a.bytes,0))/1024/1024/1024 as 未使用G from dba_free_space a where a.tablespace_name=' 表空间名称 ';
增加表空间文件(相应的文件空间就减少了)
alter tablespace 表空间名称 add datafile '/oracle/oradata/BillSysData/datafile/datafile002' size 10g ;
创建表空间
create tablespace 表空间名称 logging datafile 'D:\oracle\product\10.2.0\oradata\itmc\itmc.dbf' size 500m autoextend on next 50m maxsize 10240m extent management local;
创建临时表空间
create temporary tablespace itmctemp tempfile 'D:\oracle\product\10.2.0\oradata\itmc\itmctemp.dbf' size 500m autoextend on next 50m maxsize 1024m extent management local;
删除表空间
DROP TABLESPACE 表空间名称 INCLUDING CONTENTS AND DATAFILES;