Oracle创建表空间

--Windows系统下

--1-创建表空间

create tablespace EBSPACE datafile 'E:\app\Administrator\oradata\EBSPACE.dbf' size 100M autoextend on maxsize unlimited;

--2-创建用户并赋予权限

create user gjyw identified by gjyw default tablespace EBSPACEtemporary tablespace temp;

Grant Unlimited TableSpace To gjyw;

Grant DBA To gjyw;

drop user gjyw cascade;

drop tablespace EBSPACE;

--SUSE系统下

--1-创建表空间

create tablespace EBSPACE datafile '/opt/oracle/oradata/orcl/EBSPACE.dbf' size 100M autoextend on maxsize unlimited;

--2-创建用户并赋予权限

create user gjyw identified by gjyw default tablespace EBSPACE temporary tablespace temp;

Grant Unlimited TableSpace To gjyw;

Grant DBA To gjyw;