Book Image

Oracle APEX Cookbook

Book Image

Oracle APEX Cookbook

Overview of this book

Table of Contents (21 chapters)
Oracle APEX Cookbook Second Edition
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Creating a workspace manually


Before a developer can do something in APEX, he/she needs to have a workspace. The workspace is linked to a schema. In this recipe, you will be creating a workspace manually and assigning a schema to it.

Getting ready

Before you can implement this recipe, you need to have access to the internal workspace. The internal workspace is a special workspace where the APEX administration applications reside. There is one user created already and that is the admin user.

There are two ways to start the APEX administration:

  1. Go to http://yourhost:port/apex/apex_admin and log in using the admin login credentials. Use the link in the lower-left corner of the login page (Administration).

  2. Go to http://yourhost:port/apex and log in as admin on the internal workspace.

The password can be set using the apxxepwd.sql script. You can find this script in the APEX directory, that is, in Oracle home of the RDBMS installation or in the downloaded ZIP file of APEX. It is the same directory...