create tablespace workshop
logging
datafile '/usr/lib/oracle/xe/oradata/XE/workshop.dbf'
size 200m
autoextend on
next 20m maxsize 2048m
extent management local;
创建用户
create user workshop identified by password default tablespace workshop temporary tablespace temp;
授权
grant connect, resource, create view, create table, create procedure, create sequence, create trigger to workshop;