oracle 建表空间和用户

创建临时表空间

create temporary tablespace temp_cop 
tempfile 'E:\oracle\oradata\ORA10\temp_cop_data01.dbf'
size 32m 
autoextend on 
next 32m maxsize 2048m 
extent management local; 

创建表空间

create tablespace cop
logging
datafile 'E:\oracle\oradata\ORA10\cop_data01.dbf'
size 32m
autoextend on
next 32m maxsize 8192m
extent management local;

创建用户并指定表空间

create user username identified by password 
default tablespace cop 
temporary tablespace temp_cop; 

//给用户授予权限

grant connect,resource to username;