下载镜像
docker pull wnameless/oracle-xe-11g
运行镜像
docker run -d -p 49160:22 -p 49161:1521 wnameless/oracle-xe-11g
docker start XXXXXXX
1. 创建临时表空间
create temporary tablespace user_temp
tempfile '/u01/app/oracle/oradata/XE/user_temp.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
2.创建表空间
create tablespace user_data
logging
datafile '/u01/app/oracle/oradata/XE/user1_data.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;
3. 创建用户
create user dbo identified by oracle
default tablespace user_data
temporary tablespace user_temp;
4. 赋予权限
GRANT CONNECT,resource TO dbo;
GRANT CREATE VIEW TO dbo;