-- 创建临时表空间
create temporary tablespace ocs_temp tempfile ‘E:\app\oracle\ocs_temp.dbf‘ size 50m autoextend on next 50m maxsize 20480m extent management local;
-- 创建数据表空间
create tablespace ocs_data datafile ‘E:\app\oracle\ocs_data.dbf‘ size 50m autoextend on next 50m maxsize 20480m extent management local;
-- 创建用户并指定表空间
create user ocs identified by ocs_2018 default tablespace ocs_data temporary tablespace ocs_temp; -- 给用户授予权限 grant connect,resource,dba to ocs;