DBA Tips Archive for Oracle


[an error occurred while processing this directive]

No Title

[an error occurred while processing this directive]

by Michael New, MichaelNew@earthlink.net, Gradation LLC



Oracle Application Express (APEX), formerly called HTML DB, is a rapid web application development tool for the Oracle database. Using only a web browser and limited programming experience, you can develop and deploy professional applications that are both fast and secure.

After installing and configuring Oracle Application Express, one of the first tasks you will need to perform is to create a new Workspace. Any application you create in Oracle Application Express will be contained in a workspace. This article provides the steps along with valuable tips used to create a new Workspace in Oracle Application Express 2.x. For the purpose of this article, I will be using instructions and screenshots using Oracle Application Express 2.2.

Instructions for installing and configuring Oracle Application Express can be found at:

About Workspaces

In Oracle Application Express, all applications need to reside in a workspace. A workspace is a logical container for one or more applications. When a developer wants to work on an application, he or she will need to first login to the workspace that contains the application. Many developers can be granted privileges at a workspace. A workspace also has what is known as a Workspace Administrator. A workspace can have one or more workspace administrators. A workspace administrator can be assigned when the workspace is being created. Please note that while it is possible for a workspace administrator to perform development work on an application, this is not good practice as it makes auditing more difficult. Oracle Application Express tracks all changes to application objects and allows you to track those changes. Having a separate account for each developer allows you to easily track and report on those changes with the knowledge of who is making the modifications.

In this article, we will walk through the steps involved to create a workspace as well as creating a workspace administrator and a developer.

Creating a Workspace

Creating a workspace is done through the Oracle Application Express Administration Interface and is typically located at:

Oracle Application Express 2.2


Oracle Application Express 2.0


Steps to Manually Create a Workspace

  1. The first page will be a login screen. Here you will need to login with the username ADMIN and the password you entered during the installation of Oracle Application Express. The password was entered during the "Create Oracle Application Express Database Objects" phase of the install process. For example:

    SQL> @apexins.sql apexpwd apex22 apex22 temp /i/ TESTDB

  2. Using the "Manage Workspaces" icon, click on the down arrow to select "Create Workspace". This will start the Create Workspace wizard.

  3. The first page in the wizard allows you to identify the workspace by supplying a unique name and a short description. For the purpose of this article, I will use:

    Workspace Name IDEV_TEST
    Workspace Description Testing workspace for idevelopment.info

    Click [Next>] to continue.

  4. The "Identify Schema" screen allows you to decide whether or not to use an existing Oracle database schema or to create a new one. This schema will be used to store and access the database objects you will be use for applications. If a schema already exists for the database objects you wish to use, you would select "Yes" to re-use an existing schema and provide the name of the schema. For the purpose of this article, I will not be re-using an existing schema and be creating a new one. In this case, I will select "No" to re-use an existing schema, supply the new database schema name, password to use for the new schema, and size of the tablespace to be used for storing the database objects. Here are the values I used for the "Identify Schema" page:

    Re-use existing schema? No
    Schema Name IDEV_TEST
    Schema Password IDEV_TEST
    Space Quota Large: 50 Megabytes

    Click [Next>] to continue.

  5. The "Identify Administrator" screen allows you to configure the Workspace Administrator for the new workspace. You will be required to enter the workspace administrator username, password, and email contact information. The email is a convenient feature that allows developers to quickly get in touch with the workspace administrator. I generally like to stick with the convention of using ADMIN for the workspace administrator. Here are the values I used for the "Identify Administrator" page:

    Administrator Username ADMIN
    Administrator Password manager
    First Name Jeffrey
    Last Name Hunter
    Email jhunter@idevelopment.info

    Click [Next>] to continue.


    Note that passwords in Oracle Application Express are case-sensitive!

  6. The final page in the wizard is the "Confirm Request" screen which allows you to verify the values entered. From here you can go back to previous screens to modify values or to cancel the create workspace operation altogether. If you are satisfied with the values entered click [Create] to create the new workspace.


    It is always a good idea to print "Confirm Request" screen for future reference.

  7. After Oracle Application Express creates the new workspace, you will be presented with the "Workspace successfully provisioned" screen. As with the "Confirm Request" screen, it is always a good idea to print this screen for future reference. You should also take note of the Oracle tablespace and datafile that was created for the new database schema.

  8. Click the [Done] button.

Creating a New Developer Account

When I introduced the concept of a workspace, I mentioned that although it is possible to perform development work as the Workspace Administrator, it is never good practice. So in this section, we will create a development account.


Managing developer and user accounts in Oracle Application Express 2.0 is not done through the Oracle Application Express Administration Interface. If you are using Oracle Application Express 2.0 you will need login to the Development Interface which is accessible from the normal login page. The URL is generally in the format:


From there use the "Administration" icon and click the down arrow button to select "Manage HTML DB Users".

Oracle Application Express 2.2 users can use either the Development Interface or the Administration Interface to manage user accounts.

Create New Developer Account

  1. You should still be logged into the Oracle Application Express Administration Interface. If not, login using the method documented in the previous section.

  2. Using the "Manage Workspaces" icon, click on the down arrow to select "Manage Developers and Users". This will bring up the "Manage Developers and Users" page.

  3. Click the [Create>] button to bring up the "Edit User" page. Filling out the form should be straightforward.


    Note that passwords in Oracle Application Express are case-sensitive!

    User Name jhunter
    Email Address jhunter@idevelopment.info
    Default Schema IDEV_TEST
    Workspace IDEV_TEST
    First Name Jeffrey
    Last Name Hunter
    Description Sr. DBA / Software Engineer
    Password xxxxxxx
    User is a developer Yes
    User is an administrator No

    Click the [Create>] button to create the user.

  4. Log out of the Administration Interface by using the "Logout" link in the upper right corner of the page.

  5. Navigate to the Oracle Application Express Development Interface. The URL is generally in the format:


  6. Login to the workspace as the newly created developer:

    Workspace IDEV_TEST
    Username jhunter
    Password developer

    Click the [Login] button.

  7. If the login was successful, you should have the Workspace home page displayed:

  8. Start developing!

About the Author

Jeffrey Hunter is an Oracle Certified Professional, Java Development Certified Professional, Author, and an Oracle ACE. Jeff currently works as a Senior Database Administrator for The DBA Zone, Inc. located in Pittsburgh, Pennsylvania. His work includes advanced performance tuning, Java and PL/SQL programming, developing high availability solutions, capacity planning, database security, and physical / logical database design in a UNIX / Linux server environment. Jeff's other interests include mathematical encryption theory, tutoring advanced mathematics, programming language processors (compilers and interpreters) in Java and C, LDAP, writing web-based database administration tools, and of course Linux. He has been a Sr. Database Administrator and Software Engineer for over 20 years and maintains his own website site at: http://www.iDevelopment.info. Jeff graduated from Stanislaus State University in Turlock, California, with a Bachelor's degree in Computer Science and Mathematics.

Copyright (c) 1998-2018 Jeffrey M. Hunter. All rights reserved.

All articles, scripts and material located at the Internet address of http://www.idevelopment.info is the copyright of Jeffrey M. Hunter and is protected under copyright laws of the United States. This document may not be hosted on any other site without my express, prior, written permission. Application to host any of the material elsewhere can be made by contacting me at jhunter@idevelopment.info.

I have made every effort and taken great care in making sure that the material included on my web site is technically accurate, but I disclaim any and all responsibility for any loss, damage or destruction of data or any other property which may arise from relying on it. I will in no case be liable for any monetary damages arising from such loss, damage or destruction.

Last modified on
Wednesday, 28-Dec-2011 13:46:00 EST
Page Count: 3741