CentOS 6.3 (Linux) Oracle 10G 创建用户、表空

[user@user ~]$ sqlplus /nolog

SQL> conn sys/pwd123 as sysdba

SQL> startup

[user@user ~]$ lsnrctl start

创建临时表空间

create temporary tablespace user01_temp
tempfile '/opt/oracle/oradata/user01/user01_temp.dbf'
size 128m;

创建数据表空间

create tablespace user01
logging
datafile '/opt/oracle/oradata/user01/user01.dbf'
size 1024m;

创建用户并指定表空间

create user user01 identified by pwd123
default tablespace user01
temporary tablespace user01_temp;

给用户授予权限

grant connect,resource to user01;

CentOS 6.3 (Linux) Oracle 10G 创建用户、表空间及权限