Manage Database Schema Association with Oracle Application Express

For database schemas to be used by Oracle Application Express, the schema and Oracle Application Express must be associated. These types of associations can be created and removed.

Create an Association between a Database Schema and Oracle Application Express

In order for a schema to be accessible from Oracle Application Express, the schema must be associated with Oracle Application Express. A schema can be associated during the schema creation process, or from the Service Console after it has been created. Default schemas are automatically associated when the service is provisioned and do not require any additional steps to use them from Oracle Application Express.

Note:

You can also associate a schema with Oracle Application Express at the time of schema creation by selecting the Allow Access from APEX option. See Create a Database Schema Using the Service Console.

To associate a schema with Oracle Application Express:
  1. Go to the Manage page of the service console and click Instance Administration under Application Express section. See About Manage.
    Oracle Application Express Instance Administration page appears.
  2. Click Manage Workspace.
    The Manage Workspace options appear.
  3. Under Workspace Actions, click Manage Workspace to Schema Assignments.
    The Manage Workspace to Schema Assignments page appears, listing all workspaces in your environment along with their associated schemas. This page displays as an interactive report. To customize the report, use the Search bar at the top of the page.
  4. To edit an existing schema and workspace assignment, click on a workspace, select a different Workspace or Database Schema.
  5. Click Apply Changes.
To manage workspace to schema assignments, see Managing Workspace to Schema Assignments in Oracle Application Express Administration Guide.

Remove an Association between a Database Schema and Oracle Application Express

Database schemas are only visible from Oracle Application Express if they are associated with Oracle Application Express. Associations can be created and removed.

To find out more about associating a Database Schema with Oracle Application Express, see Manage Database Schema Association with Oracle Application Express.

To remove an association between a schema and Oracle Application Express:
  1. Go to the Manage page of the service console and click Instance Administration under Application Express section. See About Manage.
    The Oracle Application Express Instance Administration page appears.
  2. Click Manage Workspace.
    The Manage Workspace options appear.
  3. Under Workspace Actions, click Manage Workspace to Schema Assignments.
    To manage workspace to schema assignments, see Managing Workspace to Schema Assignments in Oracle Application Express Administration Guide.