My task is to move an APEX installation to a new one.
Exact: The customer wants to downgrade from Enterprise Edition to Standard Edition.
Database version is 9.2.0.8 (both), APEX version is 2.2.1
What I've done:
- Full database export (from EE)
- Delete EE-software, reboot server
- Install. SE-software, reboot server, create db
- Full database import
around 40 db objects are invalid after recompile
:-(
--------------------------------------------------------------------------------------------------------
2. try:
- create db (SE)
- Install. of APEX 2.2.1
- Import of the schemas flows_020200, flows_files and the APEX user-schemas
- recompile
all db objects are valid, but the APEX applications belongs to a workspace "unknown" so no workspace have access to its applications
:-(
Has anybody an idea or a recipe for me?
Many thanks
Ralph