Oracle创建表空间

--1.创建临时表空间
create temporary tablespace risendb_temp

tempfile 'D:\oracle\workspace\risendb_temp.dbf'

size 50m

autoextend on

next 50m maxsize 20480m

extent management local;
--2.创建用户表空间
create tablespace risendb

logging

datafile 'D:\oracle\workspace\risendb_data.dbf'

size 50m

autoextend on

next 50m maxsize 20480m

extent management local;

--3.创建用户分配表空间
create user 用户名  identified by 密码

default tablespace risendb

temporary tablespace risendb_temp;
--4.给用户分配权限
grant connect,resource,dba to risen2012;