Oracle创建表空间和用户
Oracle sql代码
–创建表空间
create tablespace epet_tablespace
datafile 'E:\app\Administrator\oradata\coolick\coolick.dbf'
size 100M
autoextend on next 32M maxsize unlimitoracle账号ed
logging
extent management local www.2cto.com
segment space management auto;
create user yanxiaojia –用户名
identified by xiao –密码
default tablespace epet_tablespace;
–权限 登录和创建表权限
grant dba to yanxiaojia;
摘自 闫小甲的博客