ADD_WORKSPACE Procedure

Adds a workspace to an Oracle APEX Instance.

Syntax

APEX_INSTANCE_ADMIN.ADD_WORKSPACE (
    p_workspace_id        IN NUMBER DEFAULT NULL,
    p_workspace           IN VARCHAR2,
    p_source_identifier   IN VARCHAR2 DEFAULT NULL,
    p_primary_schema      IN VARCHAR2,
    p_additional_schemas  IN VARCHAR2,
    p_rm_consumer_group   IN VARCHAR2 DEFAULT NULL,
    p_host_prefix         IN VARCHAR2 DEFAULT NULL );

Parameters

Parameter	Description
`p_workspace_id`	The ID to uniquely identify the workspace in an APEX instance. This may be left null and a new unique ID is assigned.
`p_workspace`	The name of the workspace to be added.
`p_source_identifier`	A short identifier for the workspace used when synchronizing feedback between different instances.
`p_primary_schema`	The primary database schema to associate with the new workspace.
`p_additional_schemas`	A colon delimited list of additional schemas to associate with this workspace.
`p_rm_consumer_group`	Resource Manager consumer group which is used when executing applications of this workspace.
`p_host_prefix`	If set, users can only navigate to an application if the URL's hostname part contains this value. Instance administrators can configure more specific values at workspace level.

Example

The following example demonstrates how to use the ADD_WORKSPACE procedure to add a new workspace named MY_WORKSPACE using the primary schema, SCOTT, along with additional schema mappings for HR and OE.

BEGIN
    APEX_INSTANCE_ADMIN.ADD_WORKSPACE (
        p_workspace_id       => 8675309,
        p_workspace          => 'MY_WORKSPACE',
        p_primary_schema     => 'SCOTT',
        p_additional_schemas => 'HR:OE' );
END;