创建表空间

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;

ITPub博客

创建表空间和用户