1、创建表空间
//永久空间
CREATE TABLESPACE USERNAME_DATA
DATAFILE 'USERNAME_DATA.DBF'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
//临时空间
CREATE TEMPORARY TABLESPACE USERNAME_TEMP
TEMPFILE 'USERNAME_TEMP.DBF'SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL;
2、创建用户并指定表空间
CREATE USER username IDENTIFIED BY passwordACCOUNT UNLOCK
DEFAULT TABLESPACE USERNAME_DATA
TEMPORARY TABLESPACE USERNAME_TEMP;
3、授权
GRANT CONNECT,RESOURCE TO username;