What is the generally accepted and best way to perform scripted workspace imports?
I have had success with using APEXExport utility and then later using SQLcl or sqlplus to script some deployments of the resulting application and page export files to higher level environments. However, when I need to import the Workspace itself, I need some guidance.
I have tried first creating the parsing schema for the workspace, then using that parsing schema as the logged in user to execute the workspace import file. This executes with no error messages, however the workspace does not appear in the APEX instance admin's Manage Workspaces interface afterward, leading me to believe this is not a viable way to install workspaces.
I see in the header of the workspace export file this advice:
-- Import:
-- Using Instance Administration / Manage Workspaces
-- or
-- Using SQL*Plus as the Oracle user APEX_190100
In our instances that software owner schema is always locked, and the password unknown. If that is indeed the correct route, I don't see how i can use that, unless I at least convince the DBA to unlock it, change the password and I suppose relock when finished.