Oracle创建表空间

--创建临时表空间
CREATE TEMPORARY TABLESPACE TS_TMP 
TEMPFILE 'D:\ORACLE\ORADATA\TMP\TMP.DBF' 
SIZE 32M 
AUTOEXTEND ON 
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;


--创建数据表空间
CREATE TABLESPACE TS_DATA
LOGGING
DATAFILE 'D:\ORACLE\ORADATA\TMP\DATA.DBF' 
SIZE 32M 
AUTOEXTEND ON 
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;

--创建用户并指定表空间
CREATE USER db IDENTIFIED BY db
DEFAULT TABLESPACE TS_DATA
TEMPORARY TABLESPACE TS_TMP;

--给用户授予权限
GRANT CONNECT, RESOURCE TO db;