oracle创建表空间

-- 01 创建临时表空间
create temporary tablespace xxx_temp 
tempfile '本地路径' size 100m autoextend on next 50m maxsize 200m;
--drop  tablespace xxx_temp including contents and datafiles;


-- 02 创建表空间
create tablespace xxx
datafile '本地路径' size 200m autoextend on next 100m maxsize 400m;
--drop  tablespace xxx including contents and datafiles;
--alter tablespace xxx add datafile 'D:\xx\xx.dbf' size 200m autoextend on;


-- 03 创建用户并制定表空间
create user xxx identified by xxx
default tablespace xxx
temporary tablespace xxx_temp;


-- 04 赋权
grant dba to xxx;