Oracle数据库创建表空间、用户
–创建临时表空间
create temporary tablespace USER_TEMP
tempfile 'C:\oraclexe\oradata\XE\USER_TEMP.dbf '
size 50m www.2cto.com
autoextend on
next 50m maxsize 20480m
extent management local;
–创建表空间
create tablespace EPO_DATA
logging
datafile 'C:\oraclexe\oradata\XE\EPO_DATA.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
www.2cto.com
–删除用户
drop user epo cascade;
–创建用户
create user EPO identified by oracle账号epo
default tablespace EPO_DATA
temporary tablespace TEMP;
–给用户授权
grant connect, resource, dba to EPO;
作者 九爷