1.创建表空间
create tablespace TESTDOMAIN
datafile 'TESTDOMAIN.dbf'
size 1500M
autoextend on next 5M maxsize 3000M;
2.授权使用表空间
alter user SYNC quota unlimited on TESTDOMAIN;
3.授权用户相关权限
grant connect,resource to SYNC;
grant create any sequence to SYNC;
grant create any table to SYNC;
grant delete any table to SYNC;
grant insert any table to SYNC;
grant select any table to SYNC;
grant unlimited tablespace to SYNC;
grant execute any procedure to SYNC;
grant update any table to SYNC;
grant create any view to SYNC;