搜索可用的Oracle镜像
拉取Oracle镜像
docker pull truevoly/oracle-12c
创建Docker容器
-- 这里使用宿主机8090端口关联oracle控制台的8080端口,1521对应oracle服务的1521端口,使用本机共享目录/Users/zhangxin/oracle/data绑定容器重的/u01/app/oracle目录
docker run --name oracle -d -p 8090:8080 -p 1521:1521 -v /Users/zhangxin/oracle/data:/u01/app/oracle truevoly/oracle-12c
默认数据库信息
数据库信息 | |
---|---|
主机名 | localhost |
端口 | 1521 |
SID | xe |
用户名 | system/sys |
密码 | oracle |
数据库环境初始化
create user OES511 identified by OES511;
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW,DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,DBA,CONNECT,RESOURCE,CREATE SESSION TO OES511;
create tablespace OES511 datafile '/u01/app/oracle/AHSL/OES51101.dmp' size 512M autoextend on next 500M maxsize unlimited;
alter user OES511 default tablespace OES511;
create or replace directory dir_oesahsl_dp as '/u01/app/oracle/AHSL';
Grant read,write on directory dir_oesahsl_dp to OES511;
ALTER TABLESPACE OES511 ADD DATAFILE '/u01/app/oracle/AHSL/OES51102.dbf' SIZE 500M AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED;
ALTER TABLESPACE OES511 ADD DATAFILE '/u01/app/oracle/AHSL/OES51103.dbf' SIZE 500M AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED;
ALTER TABLESPACE OES511 ADD DATAFILE '/u01/app/oracle/AHSL/OES51104.dbf' SIZE 500M AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED;
ALTER TABLESPACE OES511 ADD DATAFILE '/u01/app/oracle/AHSL/OES51105.dbf' SIZE 500M AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED;
ALTER TABLESPACE OES511 ADD DATAFILE '/u01/app/oracle/AHSL/OES51106.dbf' SIZE 500M AUTOEXTEND ON NEXT 500M MAXSIZE UNLIMITED;
-- 导入数据库
impdp OES511/OES511@ORCL DIRECTORY=dir_oesahsl_dp DUMPFILE=20220206230001.dmp REMAP_SCHEMA=OES511:OES511 REMAP_TABLESPACE=OES511:OES511 full=y transform=oiD:n
-- 导入数据库排除大容量表
impdp OES511/OES511@ORCL DIRECTORY=dir_oesahsl_dp DUMPFILE=OES511.dmp REMAP_SCHEMA=OES511:OES511 REMAP_TABLESPACE=OES511:OES511 full=y transform=oiD:n exclude=tablD:\"in(\'DEPT_INCOME_DAY\',\'ACCT_CHARGE_DETAIL_WJ_VIEW_HZ\')\"
-- 还原指定表
impdp OES511/OES511@ORCL DIRECTORY=dir_oesahsl_dp DUMPFILE=20220206230001.dmp REMAP_SCHEMA=OES511:OES511 REMAP_TABLESPACE=OES511:OES511 include=tablD:\"in(\'MATE_WHR_MAIN\',\'MATE_WHR_DETAIL\')\"
--删除用户,及级联关系也删除掉
drop user OES511 cascade;
--删除表空间,及对应的表空间文件也删除掉
drop tablespace OES511 including contents and datafiles cascade constraint;
-- 查询字符集
select userenv('language') from dual;
-- 更新用户密码
UPDATE UP_ORG_USER set password='xMpCOKC5I4INzFCab3WEmw=='