oracle创建用户和表空间

create tablespace <tablespace> datafile '<datafile>' size 50M autoextend on;
--增加表空间
alter tablespace <tablespace> add datafile '<datafile>' size <size>;
--创建用户
create user <username> identified by <password> default tablespace <tablespace>;
--授权
grant dba to <username>;
--或
grant resource,connect to <username>;

--删除表空间
drop tablespace <tablespace> including contents and datafiles;
--删除用户
drop user <username> cascade;