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

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