REMOVE_WORKSPACE Procedure

32.26 REMOVE_WORKSPACE Procedure

This procedure removes a workspace from an Oracle APEX instance.

Syntax

APEX_INSTANCE_ADMIN.REMOVE_WORKSPACE (
    p_workspace         IN VARCHAR2,
    p_drop_users        IN VARCHAR2 DEFAULT 'N',
    p_drop_tablespaces  IN VARCHAR2 DEFAULT 'N' )

Parameters

Parameter	Description
`p_workspace`	The name of the workspace to be removed.
`p_drop_users`	`Y` to drop the database user associated with the workspace. The default is `N`.
`p_drop_tablespaces`	`Y` to drop the tablespace associated with the database user associated with the workspace. The default is `N`.

Example

The following example demonstrates how to use the REMOVE_WORKSPACE procedure to remove an existing workspace named MY_WORKSPACE, along with the associated database users and tablespace.

BEGIN
    APEX_INSTANCE_ADMIN.REMOVE_WORKSPACE('MY_WORKSPACE','Y','Y');
END;

Parent topic: APEX_INSTANCE_ADMIN