一、表空间授权用户
create tablespace bytpms
logging
datafile 'd:\bytpmsdata\orcl\bytpms.dbf'
size 1024m
autoextend on
next 50m maxsize 1048m
extent management local;
-- 创建用户
create user bytpms
identified by "bytpms"
default tablespace bytpms
temporary tablespace TEMP
profile DEFAULT;
--用户授权
grant connect to bytpms with admin option;
grant resource to bytpms with admin option;
grant imp_full_database to bytpms with admin option;
grant exp_full_database to bytpms with admin option;