oracle基本操作-docker安装
需积分: 5 101 浏览量
2023-06-30
20:32:37
上传
评论
收藏 16KB DOCX 举报
下载
docker pull wnameless/oracle-xe-11g
参考： docker pull wnameless/oracle-xe-11g-r2
启动
docker run -d -p 1521:1521 --name=oracle --restart=always -e
ORACLE_ALLOW_REMOTE=true docker.io/wnameless/oracle-xe-11g
操作
远程登陆
sid 是实例名：xe
root@24642a8f4069:/# sqlplus system/oracle@10.100.4.54:1521/xe
SQL*Plus: Release 11.2.0.2.0 Production on Fri Jul 26 07:22:49 2019 Copyright (c)
1982, 2011, Oracle. All rights reserved. Connected to: Oracle Database 11g
Express Edition Release 11.2.0.2.0 - 64bit Production
查看用户表
SQL> select name from v$datafile; NAME --------------------------------------------
------------------------------------ /u01/app/oracle/oradata/XE/system.dbf
/u01/app/oracle/oradata/XE/sysaux.dbf
/u01/app/oracle/oradata/XE/undotbs1.dbf /u01/app/oracle/oradata/XE/users.dbf
创建
SQL> CREATE TABLESPACE customerchat LOGGING DATAFILE
'/u01/app/oracle/oradata/XE/customerchat.dbf' SIZE 100M AUTOEXTEND ON
NEXT 32M MAXSIZE 500M EXTENT MANAGEMENT LOCAL; Tablespace created.
SQL>
资源评论
