Oracle创造表空间和用户

Oracle创建表空间和用户

--创建表空间create tablespace epet_tablespace       datafile 'E:\app\Administrator\oradata\coolick\coolick.dbf'       size 100M       autoextend on next 32M maxsize unlimited       logging        extent management local       segment space management auto;create user  yanxiaojia    --用户名       identified by  xiao    --密码       default tablespace epet_tablespace;       --权限  登录和创建表权限       grant dba to yanxiaojia;