oracle创建表空间+用户

1、创建临时表空间

--create temp tablespace

create temporary tablespace test_temp

tempfile 'd:\oracle11\oradata\tablespaces\test_temp.dbf'

size 50m

autoextend on

next 50m maxsize 20480m

extent management local;

2、创建默认表空间

--create default tablespace

create tablespace test

logging

datafile 'd:\oracle11\oradata\tablespaces\test.dbf'

size 50m

autoextend on

next 50m maxsize 20480m

extent management local;

commit;

3、创建用户

--create the user(用户名a1 密码123)

create user a1 identified by 123

default tablespace test

profile default;

4、给新建的用户授予操作权限

-- grant/revoke role privileges

grant connect,resource,dba to a1 with admin option;

grant unlimited tablespace  to a1 with admin option;

5、create directory
create directory db_bak as 'E:\db_bak';
grant read,write on directory db_bak to public;