oracle 建立資料表空間使用者

標籤：

1、建立普通資料表空間和使用者

//建立暫存資料表空間
create temporary tablespace oa_temp
tempfile ‘D:\app\Administrator\oradata\orcldjoa_temp.dbf‘
size 32m
autoextend on
next 32m maxsize 20480m
extent management local;

//建立資料資料表空間
create tablespace oa
logging
datafile ‘D:\app\Administrator\oradata\orcldjoa.dbf‘
size 32m
autoextend on
next 32m maxsize 20480m
extent management local;

//建立使用者
create user oa identified by oa
default tablespace oa
temporary tablespace oa_temp;

//給使用者添加許可權
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
DBA,CONNECT,RESOURCE,CREATE SESSION TO oa

drop user oa cascade;
drop tablespace oa including contents and datafiles;
drop tablespace oa_temp including contents and datafiles;

2、建立大資料表空間和使用者

//建立暫存資料表空間
create bigfile temporary tablespace sxybyj_temp
tempfile ‘E:\app\Administrator\oradata\orcl\sxybyj_temp.dbf‘
size 128m
autoextend on
extent management local
uniform size 128k

//建立資料資料表空間
create bigfile tablespace sxybyj
datafile ‘E:\app\Administrator\oradata\orcl\sxybyj.dbf‘
size 128m
autoextend on
extent management local
uniform size 128k

//建立使用者
create user sxybyj identified by sxybyj
default tablespace sxybyj
temporary tablespace sxybyj_temp;

//給使用者添加許可權
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW ,
DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
DBA,CONNECT,RESOURCE,CREATE SESSION TO sxybyj

drop user sxybyj cascade;
drop user test1 cascade;
drop tablespace sxybyj including contents and datafiles;
drop tablespace sxybyj_temp including contents and datafiles;

 

oracle 建立資料表空間使用者