按先后顺序执行一下操作即可完成用户的创建

-- 建临时表空间

create temporary tablespace UIMS_ORG_TEMP tempfile 'F:\SXF\oracledata\uims_org_temp.dbf' size 2048m autoextend on next 1024m maxsize 10240m extent management local;

-- 建表空间

create tablespace UIMS_ORG logging datafile 'F:\SXF\oracledata\uims_org.dbf' size 1048m autoextend on next 1024m maxsize 10240m extent management local;

-- Create the user

create user UIMS_ORG

  identified by "UIMS_ORG"

  default tablespace UIMS_ORG

  temporary tablespace UIMS_ORG_TEMP

  profile DEFAULT;

-- Grant/Revoke role privileges

grant connect to UIMS_ORG;

grant dba to UIMS_ORG;

grant resource to UIMS_ORG;

-- Grant/Revoke system privileges

grant execute any class to UIMS_ORG;

grant unlimited tablespace to UIMS_ORG;