Thanks for the question, Sri.
Asked: April 28, 2026 - 9:12 am UTC
Last updated: April 30, 2026 - 1:51 pm UTC
Version: 22
Viewed 100+ times
You Asked
We are planning to migrate our database from on-premises infrastructure to ODA. The source platform is Solaris sparc, and the target platform is x86. We intend to use the M5 Cross-Endian Platform Migration approach.
However, we have a question regarding whether APEX and ORDS will be migrated as part of this process. On the source system, APEX and ORDS are installed in dedicated tablespaces rather than in SYSTEM or SYSAUX.
We would like to verify whether this M5 migration is fully compatible for APEX,ORDS and whether any issues are expected.
Both Source and target DB's are in 19.25 , APEX IS 22.1
and Connor said...
M5 migrates datafiles via RMAN and the DataPump phase does a "transportable=always full=y". Which *should* bring over APEX definitions. However, APEX includes elements in the SYS schema so I assume that APEX will not simply "migrate over" with M5.
Your workflow would be:
1- export workspaces, apps from APEX on old system (SQLcl can be used to do this)
2- perform migration
3- install APEX on new system
4- import apps from (1)