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: Installing Oracle Application Express 2.0 Installing Oracle Application Express 2.2

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

Oracle Application Express 2.2

http://<machine_name>:7777/pls/apex/apex_admin

Oracle Application Express 2.0

http://<machine_name>:7777/pls/htmldb/htmldb_admin

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.

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: http://<machine_name>:7777/pls/htmldb/htmldb_login 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:

   http://<machine_name>:7777/pls/apex/apex_login

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!