用System登录,创建独立的表空间:
创建用户:
授予开发权限:
create tablespace pkdev_test datafile '/opt/oracle/oradata/orcl/pkdev_test.dbf' size 500m extent management local;
创建用户:
create user 用户名 identified by 密码 default tablespace pkdev_test temporary tablespace temp quota unlimited on pkdev_test quota 0m on system;
授予开发权限:
grant connect to test;