oracle 创建表空间和用户

1.创建临时表空间

create temporary tablespace appstemptsp  
tempfile '/oracle/app/oracle/oradata/orcl/appstemp01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;

2.创建表空间

create tablespace appstsp
logging
datafile '/oracle/app/oracle/oradata/orcl/apps01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local;

3.创建用户并指定表空间

create user apps identified by apps
default tablespace appstsp
temporary tablespace appstemptsp;

4.给用户赋权

grant connect,resource,dba to apps;