ORACLE创建表空间及授权

– 创建表空间

CREATE tablespace LA_TREE 
logging 
datafile 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\LA_TREE.DBF' 
SIZE 50m autoextend ON 
next 50m maxsize 2048m extent management local;

– 创建用户

CREATE USER "LA_TREE" IDENTIFIED BY "LA_TREE" DEFAULT tablespace LA_TREE;

-- 赋予权限
GRANT CONNECT, RESOURCE, dba TO "LA_TREE";