Oracle Apex - Workspace

Card Puncher Data Processing

About

A workspace is a virtual private database allowing multiple users to work within the same Oracle Application Express installation while keeping their objects, data and applications private. Each workspace has a unique ID and name. One Apex can have one or several workspace.

The Internal workspace is the administration workspace of the Apex Instance (if you want to create a new workspace, configure email settings, …)

In a workspace, you can manage :

You can see :

  • Tablespace Utilization
  • Privileges
  • Objects by Type (Database Link, Table, Function, Index, …)
  • Change Requests
  • Role Privileges
  • User Activity
  • Developer Activity

Properties

Name

APEX_UTIL.FIND_WORKSPACE returns the workspace name associated with a security group ID.

Id

l_workspace_id := TO_CHAR(APEX_UTIL.FIND_SECURITY_GROUP_ID('MY_WORKSPACE'));

If you want to run script outside the Apex Web application (ie in the database), you need to set the workspace id for all Apex function.

Management

Provisioning

See creation

Creation

See Oracle Apex - (Internal Workspace|Administration)

When an Instance administrator creates a new workspace with a new schema, a new tablespace and data file are created for that schema.

If Oracle-managed files is:

  • enabled, it manages the data file for the new tablespace. The placement of these files is determined by the database initialization parameter DB_CREATE_FILE_DEST.
  • not enabled, the data file is created in the same directory as the first data file of the tablespace in which Oracle Application Express is installed.

More Creating Workspaces

Remove

Request

Managing Workspace and Change Requests

Find

In the login page

Apex Find Workspace

where you can enter your email to receive the email below:

Your email address is registered with a user in the following workspaces::

Workspace: DEV
Username: NICOLAS

Workspace: NICOLAS
Username: ADMIN


http://localhost:8080/orcl/

Parameter

See Available Parameter Values in the APEX_INSTANCE_ADMIN package.

The property of a workspace can be changed through:

BEGIN 
    APEX_INSTANCE_ADMIN.SET_PARAMETER(PARAMETER_NAME, PARAMETER_VALUE);
END;





Discover More
Apex Find Workspace
Oracle Apex - (Internal Workspace|Administration)

Internal (or Administration) is an administration application aimed to manage workspace instance. (Ie one Apex installation can have several workspace) In the login page A workspace instance...
Card Puncher Data Processing
Oracle Apex - (Security Group|Workspace Id) (Apex Context)

The security group id is the workspace id. Setting the security group id specify the workspace. It is especially useful when: you want to use an APEX function outside Apex (ie in the database) (Thanks...
Card Puncher Data Processing
Oracle Apex - Mail

Mail in Apex can be sen with the package. API The most efficient approach to sending email is to create a background job (using the DBMS_JOB or DBMS_SCHEDULER package) to periodically send all mail...
Apex Find Workspace
Oracle Apex - Password

In the login page, See the APEX_INSTANCE_ADMIN Available Parameter Values: ACCOUNT_LIFETIME_DAYS PASSWORD_ALPHA_CHARACTERS PASSWORD_MIN_LENGTH PASSWORD_NEW_DIFFERS_BY PASSWORD_PUNCTUATION_CHARACTERS...
Card Puncher Data Processing
Oracle Apex - Shortcut

The Search Workspace box has the following shortcut: To navigate to a specific application and page use the following formats: where: application id page
Oracle Apex Application Security Public User
Oracle Apex - User

A user in Apex. Once a user has been identified, the Application Express engine keeps track of each user by setting the value of the variable APP_USER. APP_USER...
Apex Find Workspace
Oracle Apex - Workspace

A workspace is a virtual private database allowing multiple users to work within the same Oracle Application Express installation while keeping their objects, data and applications private. Each workspace...



Share this page:
Follow us:
Task Runner