oracle 创建表空间和用户

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;

 

oracle 创建表空间和用户

标签：