Oracle表空间、用户基本操作

-- 创建表空间
CREATE TABLESPACE xtgx DATAFILE 'xtgx.dbf' SIZE 500M UNIFORM SIZE 10M;
-- 创建用户
create user xtgx identified by xtgx;
-- 给用户设置密码
alter user xtgx identified by 123456;
-- 用户赋权
grant connect,resource,dba to xtgx;

-- 删除表空间
DROP TABLESPACE xtgx INCLUDING CONTENTS AND DATAFILES;
-- 删除用户
drop user xtgx cascade;