working on applications and technology

What is Apex workspace?

Workspace is an very important concept for Apex, We know that a tablespace is a container for database data, and apex workspace is like an 'container' for Apex Applications and data. Usually a workspace is related with a database schema, the apex applications definition and data will be stored in the schema default tablespace. The relationship is as the following graph:

The application express concept workspace is logical concept and all the apex definition and data is stored in the related database tablespace of the schema.

Steps to create workspace

First we have to go to the apex administration web page, We could use the browser to point to the address of

http://yourApexIP/apex/apex_admin

use the administration account to login into the console and you could see many administration task including creating workspace

Under the 'Manage workspace' , just click 'Create Workspace'

In the next page, you could just select an existing database schema to store the workspace or creating another schema by entering schema name and password.

After entering the neccessary schema information, we could just leave other option with their default value and finishing the workspace creation.

After successful creation of the workspace, we could just logout and use our browser to point to the address http://yourapexIP/apex

Now we could enter our new workspace name in the field and login to create our apex applications!