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;