Oracle新建表空间、新建用户、授权

新建临时表空间

create temporary tablespace test_temp

tempfile 'C:/oracle/oradata/TFServer/test_temp.dbf'

size 500m

autoextend on

extent management local;

---

新建表空间

create tablespace test

logging

datafile 'C:/oracle/oradata/TFServer/test.dbf'

size 10000m

autoextend on

extent management local;

---

新建用户

create user sam identified by 123456 
default tablespace TEST 
temporary tablespace TEST_TEMP 
quota unlimited on TEST;

---

授权

GRANT CREATE ANY VIEW,DROP ANY VIEW,
EXP_FULL_DATABASE,IMP_FULL_DATABASE,
CONNECT,RESOURCE,CREATE SESSION TO sam;