/*第1步:创建临时表空间 */
create temporary tablespace db_temp tempfile
'D:/dboa/oracle/db_temp.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;
create temporary tablespace htoa_temp tempfile
'/home/oracle/htoa_temp.dbf'
size 50m autoextend on next 50m maxsize 20480m extent management local;
/*第2步:创建数据表空间 */
create tablespace db_data logging datafile '
D:/dboa/oracle/db_data.dbf ' size 50m autoextend on next 50m maxsize 2048m extent management local;
create tablespace htoa_data logging datafile '/home
/oracle/
htoa_data
.dbf
' size 50m autoextend on next 50m maxsize 2048m extent management local;
/*第3步:创建用户并指定表空间 */
create user htoa identified by htoa default tablespace htoa_data temporary tablespace htoa_temp ;
/*第4步:给用户授予权限 */
grant connect,resource,dba to htoa ;
/*删除用户 */
drop user htoatemp cascade