Oracle用命名创建表空间和用户

创建临时表空间 :

 

CREATE TEMPORARY TABLESPACE test_temp
TEMPFILE 'D:\app\Administrator\oradata\orcl\test_temp01.dbf '
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;

 

创建用户表空间:
CREATE TABLESPACE test_data
LOGGING
DATAFILE 'D:\app\Administrator\oradata\orcl\TEST_DATA01.DBF'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;

 

 

创建用户并制定表空间:
CREATE USER test_user IDENTIFIED BY 12345
DEFAULT TABLESPACE TEST_DATA
TEMPORARY TABLESPACE TEST_TEMP;

 

给用户赋予权限：
Grant connect,resource,dba to test_user;