oracle 创建 用户 表空间 授权示例

drop user u_melon cascade;
drop tablespace u_melon_hq including contents and datafiles cascade constraints;
drop tablespace u_melon_hq_temp including contents and datafiles cascade constraints;

--SERVICE_NAME替换为数据库的SERVICE_NAME
create tablespace u_melon_hq
datafile 'u_melon_hq.dbf' size 1g
autoextend on next 200m
maxsize unlimited;

create temporary tablespace u_melon_hq_temp
tempfile 'u_melon_hq_temp.dbf' size 200m;

create user u_melon
identified by p_melon
default tablespace u_melon_hq
temporary tablespace u_melon_hq_temp
account unlock;

--grant dba to secfox;

grant resource to u_melon;
grant connect to u_melon;

grant EXP_FULL_DATABASE to demo;
grant IMP_FULL_DATABASE to demo;

grant exp_full_database to u_melon;
grant imp_full_database to u_melon;