?
创建临时表空间(注意：D:\Project\OracleTableSpace\FHADMIN\ 手动创建路径) ?*/?
create?temporary?tablespace?C##FHADMIN_TEMP?? tempfile?‘D:\Project\OracleTableSpace\FHADMIN\C##FHADMIN_TEMP.dbf‘? size?50m?? autoextend?on?? next?50m?maxsize?20480m?? extent?management?local;
创建游戏数据表空间fhadmin.org? */
create tablespace www.sangpi.comC##FHADMIN_DATA logging?? datafile ‘D:\Project\OracleTableSpace\FHADMIN\C##FHADMIN_DATA.dbf‘? size 50m?? autoextend on?? next 50m maxsize 20480m?? extent management local;
创建用户并指定表空间 密码是root */
create?user?C##FHADMIN?identified?by?root default?tablespace?C##FHADMIN_DATA temporary?tablespace?C##FHADMIN_TEMP;
给用户授予权限fhadmin org ?*/
grant?connect,resource,dba?to?C##FHADMIN;
原文：https://blog.51cto.com/u_14967986/2908564