创建表空间

//创建临时表空间 

 

create temporary tablespace test_temp

tempfile 'D:/app/hmit/oradata/mydata/test_temp.dbf' 

size 32m 

autoextend on 

next 32m maxsize 2048m 

extent management local; 

 

//创建数据表空间 

create tablespace test

logging 

datafile 'D:/app/hmit/oradata/mydata/test.dbf' 

size 32m 

autoextend on 

next 32m maxsize 2048m 

extent management local; 

 

//创建用户并指定表空间 

create user test identified by test

default tablespace test

temporary tablespace test_temp;

 

//给用户授予权限 

 

grant connect,resource to test