Viewing Edition-Based Redefinition (EBR) schemas in APEX SQL Workspace
We are about to deploy Edition-Based Redefinition (EBR) to one of our APEX-enabled instances (Oracle EE release 19.15 off-premises). In the instance startup script, would we simply add each EBR iteration as additional schemas? For example:
call APEX_INSTANCE_ADMIN.ADD_WORKSPACE (
p_workspace_id => 100209,
p_workspace => 'APEX.DBA',
p_primary_schema => 'ABCD'
p_additional_schemas => 'SYS:ABCDADMIN:DBA1:DBA2:ABCD_SPRINTnn'
);
where nn represents the edition sequence. This implies that the workspace has to be altered with each build in order for APEX to access these schemas. TIA