第一:进入oracle用户,sqlplus / as sysdba; 登录oracle.
第二:创建临时表空间 名称为xxxx_temp
create temporary tablespace xxxx_temp tempfile '/home/oracle/oradata/orcl/xxxx_temp.dbf'size 50m autoextend on next 50m maxsize 20480m extent management local;
第三:创建数据表空间 名称为xxxx_data
create tablespace xxxx_data logging datafile '/home/oracle/oradata/orcl/xxxx_data.dbf'size 50m autoextend on next 50m maxsize 20480m extent management local;
第四:创建用户并指定表空间
create user xxxx identified by xxxx default tablespace xxxx_data temporary tablespace xxxx_temp;
第五:授权给用户
grant connect,resource to xxxx;
exit;