版权声明：欢迎评论和转载，转载请注明来源。 https://blog.csdn.net/zy332719794/article/details/49863937
--创建表空间
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;
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;
