oracle创建和删除表空间

--创建临时表空间
create temporary tablespace icer
tempfile 'D:\oracle\icer.dbf'
size 50m
autoextend on
next 50m maxsize 1024m
extent management local;

--创建数据表空间
create tablespace icer_data
logging
datafile 'D:\oracle\icer_data.dbf'
size 50m
autoextend on
next 50m maxsize 1024m
extent management local;

--删除临时表空间
drop tablespace icer;

--删除数据表空间
drop tablespace icer_data;