oracle 建表空间 用户

create tablespace Manage_Data
logging
datafile '/oradata/creditma/Manage_Data01.dbf'
size 32m
autoextend on
next 32m maxsize 2048m
extent management local
SEGMENT SPACE MANAGEMENT AUTO;

create temporary tablespace Manage_Temp
tempfile '/oradata/creditma/Manage_Temp01.dbf'
size 4096m;
 

create user XY_MANAGE identified by Password
default tablespace Manage_Data
temporary tablespace Manage_temp;

grant connect,dba,ctxapp,resource to XY_MANAGE;