以表空间SOA用户teach为例

ORACLE安装完成后一sys（最高权限）登录

 

创建表空间 CREATE  SMALLFILE TABLESPACE "SOA" DATABASE ' D/  ' SIZE 1000M REUSE AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT SPACE MANAGEMENT AUTO 创建用户 CREATE USER teach IDENTIFILD BY 111111 DEFAULT TABLESPACE teach Temporary TABLESPACE SOA 授权 grant  resource to teach; grant connect to teach; grant dba to teach; （ 删除用户及用户下的数据 drop user *** cascade； drop tablespace *** including contents and datafiles； ）