DBA Tips Archive for Oracle
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:
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 is done through the Oracle Application Express Administration Interface and is typically located at:
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:
Using the "Manage Workspaces" icon, click on the down arrow to select "Create Workspace". This will start the Create Workspace wizard.
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 Description||Testing workspace for idevelopment.info|
Click [Next>] to continue.
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|
|Space Quota||Large: 50 Megabytes|
Click [Next>] to continue.
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:
Click [Next>] to continue.
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.
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.
Click the [Done] button.
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.
You should still be logged into the Oracle Application Express Administration Interface. If not, login using the method documented in the previous section.
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.
Click the [Create>] button to bring up the "Edit User" page. Filling out the form should be straightforward.
|Description||Sr. DBA / Software Engineer|
|User is a developer||Yes|
|User is an administrator||No|
Click the [Create>] button to create the user.
Log out of the Administration Interface by using the "Logout" link in the upper right corner of the page.
Navigate to the Oracle Application Express Development Interface. The URL is generally in the format:
Login to the workspace as the newly created developer:
Click the [Login] button.
If the login was successful, you should have the Workspace home page displayed:
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 firstname.lastname@example.org.
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: 3698