3.13 Managing Existing Workspaces

Instance administrators can manage existing workspaces within an Oracle Application Express instance.

• Viewing Existing Workspace Information
  Use the Existing Workspaces report to view an interactive report of existing workspaces. From the Existing Workspaces report, you can view or edit workspace details.
• Viewing the Application Attributes Report
  View applications by workspace on the Application Attributes page.
• Deleting a Workspace
  Deleting 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.
• Locking a Workspace
  Instance administrators can lock a workspace to address security or performance issues.
• Managing Workspace to Schema Assignments
  Instance administrators can view, edit, and remove schema and workspace assignment, associate additional schemas with a workspace, and create new schemas.
• Managing Component Availability for an Instance
  Control which components are available within an Oracle Application Express instance, including App Builder, SQL Workshop, PL/SQL Editing in SQL Workshop, Team Development, or installation of productivity and sample applications.
• Performing a Workspace Search
  Perform a workspace search by clicking Find a Workspace on the Workspace Tasks page.
• Isolating a Workspace to Prevent Browser Attacks
  Workspace administrators can prevent browser attacks by isolating a specific workspace. Workspace-level settings override those configured for an entire instance.
• Viewing the Workspace Details Report
  View workspace information by viewing the Workspace Details Report.
• Viewing Workspace Database Privileges
  View a summary of workspace database privileges on the Workspace Database Privileges page.
• Viewing File Size and File Count by Workspace
  View total file size and file count by workspace on the File Utilization by Workspace page.
• Finding and Emailing Workspace Summary
  View total file size and file count by workspace on the File Utilization by Workspace page.
• Accessing the Data Dictionary Cache Report from Administration Services
  Access the Data Dictionary Cache report from Administration Services to view statistics and data analysis of all workspace schema tables and caches in an instance.
• Exporting and Importing a Workspace
  Move a workspace and all associated users to a new Oracle Application Express instance by exporting and importing.
• Exporting Workspaces, Apps, and Related Files from a Command-line
  Export workspaces, applications, and related files from a command-line using the APEXExport utility.
• Changing Application Build Status in Administration Services
  An Instance administrator can change the build status of an application.
• Viewing the Parsing Schemas Report
  Use the Parsing Schemas report to identify the current parsing schema of each application in any workspace.

See Also:

• "Creating Workspaces in Administration Services"

• "Managing Schemas"

• "Managing Users Across an Application Express Instance"

• "Monitoring Activity Across a Development Instance"