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 Use an Existing Schema and enter the name of the schema you want to add. Click on Next.

4. You will get the message you have requested stating that the existing schema be assigned to the workspace.

   We will now continue as the instance administrator...