oracle 表空间/用户 增加删除

create temporary tablespace user_temp

tempfile 'C:\dmp\user_temp.dbf'

size 50m

autoextend on

next 50m maxsize 20480m

extent management local;

/*第2步：创建数据表空间  */

create tablespace TBS_RISK

logging

datafile 'C:\dmp\TBS_RISK.dbf'

size 50m

autoextend on

next 50m maxsize 20480m

extent management local;

/*第3步：创建用户并指定表空间  */

create user RISK identified by RISK

default tablespace user_data

temporary tablespace user_temp;

/*第4步：给用户授予权限  */

grant connect,resource,dba to RISK;

drop user RISK cascade;