Trying to migrate to APEX 21.1, having exported a "Full" workspace (with users and schemas), I encounter the famous "known bug in 18.1" - ORA-01400: cannot insert NULL into ("APEX_210100"."WWV_FLOW_SW_RESULTS"."SECURITY_GROUP_ID")
Another problem is trying to import (update??) an existing workspace. The wizard takes me all the way to the end, but the actual "Install" button is missing. So how to add a "full" export to a workspace that has been imported from a "Minimal" is still a riddle.
Third problem, out of 10 assigned schemas, APEX import manages to concatenate to of the names into one, that obviously doesn't exist. I.e. if the export file includes:
,p_company_schemas => 'BCA:BCB:BCC:BCD:BCE:BC_A1:BCI:BCF:BCK:BCDISC'
then the "creative" import wizard lists them as:
"BCA"
"BCB"
"BCC"
"BCD"
"BCE"
"BCI"
"BCF"
"BCK"
"BC_A1BCDISC" <- this one doesn't exist.
Does anyone have any good advice on how to migrate a workspace?