Oracle建表空间、用户

--创建表空间
create tablespace lydev 
 datafile 'D:\OracleTableSpace\lydev.dbf' size 100M
 autoextend on next 10M maxsize unlimited;
--创建用户
create user ly_dev identified by ly_dev 
 default tablespace lydev
 temporary tablespace TEMP
 profile DEFAULT;
--授权
grant dba, connect, resource to ly_dev;