Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Configuring Workspace on runtime environment

ct.rodriguezaleApr 10 2019 — edited Apr 11 2019

I need to automate the installation of APEX 5.1 using only the runtime environment to configure the application.

I made some scripts that install and configure the application using the ADMIN user as the INTERNAL administrator, but when I create my Workspace, this is created without a user manager and I can not log in. How can I create the work area with an administrator or create a user and convert it into Administrator from my WS?

This is my code.. It is the same code that indicates the official documentation

ALTER SESSION SET CURRENT_SCHEMA = APEX_050100;

BEGIN

    APEX_INSTANCE_ADMIN.ADD_WORKSPACE (

        p_workspace_id => 100000,

        p_workspace => 'MY_WKS',

        p_primary_schema => 'WS',

        p_additional_schemas => 'HF' );

END;

/

Comments
Post Details
Added on Apr 10 2019
2 comments
201 views