1、创建表空间
create tablespace cyzspace datafile '\Users\cuiyaozhong\software\datagriporacle\cyz.dmp'
size 100M
autoextend on next 50M
maxsize unlimited
extent management local autoallocate
segment space management auto;
特别注意,我用的是mac,路径要用反斜杠“\”
2、创建用户并分配给用户
create user cyz
identified by cyz
default tablespace cyzspace;
3、给用户赋权限
grant dba,connect,resource,
aq_administrator_role,aq_user_role,
authenticateduser to cyz;