2016_ORACLE创建表空间

1,创建临时表空间
create temporary tablespace LUCKCART_TEMP
tempfile 'E:\oracle\app\oradata\orcl\LUCKCART_TEMP.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;
2，创建表空间
create tablespace LUCKCART
logging
datafile 'E:\oracle\app\oradata\orcl\LUCKCART_001.dbf'
size 100m
autoextend on
next 32m maxsize 2048m
extent management local;
3,创建用户并指定表空间

create user luckcart identified by luckcart default tablespace LUCKCART temporary tablespace LUCKCART_TEMP;

4,//授予message用户DBA角色的所有权限

GRANT DBA TO luckcart;
5,给用户授予权限

grant connect,resource to luckcart; (db2：指定所有权限)