O'Reilly logo

Oracle APEX Cookbook - Second Edition by Marcel Van Der Plas, Michel Van Zoest

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Adding a schema to your workspace

By default, a workspace has got one schema from where it uses the objects. You can add more schemas to a workspace. This recipe tells you how to do that.

There are several ways to add a schema to a workspace:

  • Log in to the internal workspace as administrator and go to Manage Workspaces | Manage Workspace to Schema Assignments
  • Log in as the workspace administrator and go to Administration | Manage Service | Make a Service Request
  • Using the API, apex_instance_admin.add_schema('<workspace>','<schema>');

Getting ready

Make sure you can log in to the internal workspace as administrator.

How to do it...

  1. Go to Administration | Manage Service | Make a Service Request.
  2. Click on the Request Schema icon.
  3. In the next step, select ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required