REMOVE_WORKSPACE Procedure

The REMOVE_WORKSPACE procedure removes a workspace from a an Application Express instance.

Syntax

PROCEDURE REMOVE_WORKSPACE(
    p_workspace         IN VARCHAR2
    p_drop_users        IN VARCHAR2 DEFAULT 'N',
    p_drop_tablespaces  IN VARCHAR2 DEFAULT 'N' );

Parameters

Table: REMOVE_WORKSPACE Parameters describes the parameters available in the REMOVE_WORKSPACE procedure.

REMOVE_WORKSPACE 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

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