oracle创建表空间和用户

1.创建表空间dcspace：

create tablespace dcspace datafile 'D:\ORACLE11G64\ORADATA\ORCL\dcspace.DBF' size 1024m
autoextend on next 100m maxsize unlimited;

2.创建用户，并指定dcspace为默认表空间：

create user dc identified by 123 default tablespace dcspace temporary tablespace temp;

3.赋予权限：

grant connect to dc;
grant resource to dc;
grant exp_full_database to dc;
grant imp_full_database to dc;
grant create any view to dc;
grant select any table to dc;
grant create any table to dc;
grant create any index to dc;
grant create any sequence to dc;
grant execute any procedure to dc;
grant unlimited tablespace to dc;

转载于:https://www.cnblogs.com/myCodingSky/p/3768930.html