Oracle APEX allows the administrator a lot of control to ensure the integrity of your web apps and data. In order to achieve that, the administrator is enabled to create an Oracle APEX workspace to separate which user has access to which web app and it’s related database.

You can create as many workspaces to cater for your user’s needs. Creation is dead simple and takes less than 5 minutes.

So what is an Oracle APEX workspace?

Before going forwards to create a workspace, it is great to know what a workspace actually is:

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 numeric ID and name.Oracle APEX Administration Guide

As an Oracle APEX administrator you can set your users to only be able to access the web apps that they need to thus keeping information safe and secured to intended eyes only.

Create an Oracle APEX workspace

Continuing from my last post about installing Oracle APEX and ORDS in Windows 10, this article is going to guide you on how to create an Oracle APEX workspace. I am going to create a workspace for my department, which is ‘IT‘. So key in your Oracle APEX 20.2 address in the browser and login to your administrator account.

If you are continuing from my previous article about installing Oracle APEX 20.2 and ORDS, the address to your APEX site should be as below:

Default address

http://localhost:8080/ords/

If it is your first time logging into APEX, the workspace and credentials used are as below:

Workspace: INTERNAL
Username: Username as set when running apxchpwd.sql script
Password: Password as set when running apxchpwd.sql script

You will be greeted by the page below and then you may proceed to create your first workspace. The INTERNAL workspace is used by administrators to manage the Oracle APEX instance.

oracle-apex-20.2-welcome
Oracle APEX welcome page

Give a name to your workspace and preferably a description so that future administrators can easily identify the use of that particular workspace.

The workspace ID will be automatically generated but you can fill it up if you’re going to run multiple Oracle APEX instances on other servers. The workspace ID must be greater than 100000.

create-IT-workspace
Identify Workspace
Workspace Name: IT
Workspace ID: *Leave blank if not necessary*
Workspace Description: IT department workspace.

On the next page, since this will be our first schema input the following information:

Re-use existing schema: No
Schema Name: IT
Schema Password: *Your preferred password*
Space Quota: 100 MB
create-IT-workspace-2
Identify Schema

If you have schemas that you want to reuse in your next workspace, you can simply find it in the ‘list‘ button besides the ‘Schema Name‘ field.

Continue by filling in the workspace administrator’s information as per your preferences.

create-IT-workspace-3
Identify Administrator

On the following page, review your selections and if all is in order, proceed to create your first Oracle APEX 20.2 workspace. Well done!

Now head over to the main APEX administration page by clicking the top left APEX logo. There you will see a bountiful of options to configure and administrate Oracle APEX and future workspaces which I will talk about in upcoming posts.

Create an Oracle APEX workspace: Accessing your new workspace

Sign out from your current administrator session in Oracle APEX and sign back in using the workspace name and administrator account that you have set just a short while ago.

new-workspace-login
Login to new Oracle APEX workspace

After your first sign-in, APEX will require you to update your password again which seems redundant at first but in business environments this will allow the user whom you have assigned an Oracle APEX workspace and initial password to update to their own preferred credential.

Since Oracle APEX is a low code tool and doesn’t require high technical knowledge to deploy simple web applications, this tool can be taught to selected citizen developers whilst leaving the IT systems administrators free to focus on managing and administrating Oracle APEX itself.

Conclusion to create an Oracle APEX workspace

Workspaces enables separation of web apps and databases to ensure security and data integrity. You can create an Oracle APEX workspace easily and as many as you need.

Workspaces can then be assigned to trained citizen developers to create and manage their own web apps as logically they would know better about their department’s needs and the IT department can facilitate the build.

This in turn would lessen the burden of the IT department and give them back focus for larger and higher impact projects.

Well that is the expected ideal scenario, but in reality we all know better right?

Good luck!

Leave a Comment

Your email address will not be published. Required fields are marked *

This div height required for enabling the sticky sidebar