--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 EBSPACE temporary 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;