Removing a Workspace

Removing a workspace does not remove any of the associated database objects. To remove the associated schemas, a database administrator (DBA) must use a standard database administration tool, such as Oracle Enterprise Manager or SQL*Plus.

Removing Workspaces in a Full Development Environment

To remove a workspace in a full development environment:

Log in to Oracle Application Express Administration Services. See "Logging in to Oracle Application Express Administration Services".
Click Manage Workspaces.
Under Workspace Reports, click Existing Workspaces.
Under the Action column, click Delete.
Follow the on-screen instructions.

Removing Workspaces in a Runtime Development Environment

To remove a workspace in a runtime development environment:

Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS. For example:
- On Windows:
```
SYSTEM_DRIVE:\ sqlplus /nolog
connect sys as sysdba
```
- On UNIX and Linux:
```
$ sqlplus /nolog
connect sys as sysdba
```
When prompted enter the appropriate password.

Run the following statement:

ALTER SESSION SET CURRENT_SCHEMA = APEX_030200

Run the following statement:
```
BEGIN
APEX_INSTANCE_ADMIN.REMOVE_WORKSPACE(WORKSPACE_NAME, DROP_USER, DROP_TABLESPACE)
END;
```
Where:
- WORKSPACE_NAME is the name of the workspace.
- DROP_USER is either Y or N. The default is N.
- DROP_TABLESPACE is either Y or N. The default is N.