17.18 REMOVE_WORKSPACE Procedure
The REMOVE_WORKSPACE
procedure removes a workspace from an Application Express 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
Table 17-16 REMOVE_WORKSPACE Parameters
Parameter | Description |
---|---|
|
The name of the workspace to be removed. |
|
|
|
'Y' to drop the tablespace associated with the database user associated with the workspace. The default is |
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