Migrate Data from Oracle 12c to 18c XE
Docker Compose
services:
oracle-db-18c:
image: gvenzl/oracle-xe:18.4.0-full
ports:
- "1523:1521" # Oracle Database listener port
- "5503:5500" # Oracle Enterprise Manager Express port
environment:
- ORACLE_PASSWORD=oracle # Set initial SYS and SYSTEM password
volumes:
- oracle-data-18c:/opt/oracle/oradata # Persist Oracle XE database files
- oracle-dump-18c:/opt/oracle/admin/XE/dpdump # Persist Oracle XE dump files
networks:
- app-network-18c
volumes:
oracle-data-18c:
oracle-dump-18c:
networks:
app-network-18c:
driver: bridge
Create Table Space
CREATE BIGFILE TABLESPACE JTCCM
DATAFILE
'DB01' SIZE 104857600 REUSE AUTOEXTEND ON NEXT 104857600 MAXSIZE UNLIMITED
BLOCKSIZE 8192
ONLINE
SEGMENT SPACE MANAGEMENT AUTO
EXTENT MANAGEMENT LOCAL AUTOALLOCATE;
Create User
ALTER SESSION SET CONTAINER=XEPDB1;
CREATE USER DB01 IDENTIFIED BY DB01 QUOTA UNLIMITED ON DB01;
GRANT CONNECT, RESOURCE TO DB01;
Copy Dump File to Container
docker cp BACKUP_ISO_xe11g.DMP 776c1be28c4d:/u01/app/oracle/admin/XE/dpdump/
Import Dump File
impdp system/oracle@localhost:1523/XEPDB1 dumpfile=BACKUP.DMP logfile=BACKUP.LOG REMAP_SCHEMA=DB_SRC:DB_DST