Server Side Objects Wizard

Previous  Index  Next  How To Use

The Server Side Objects Wizard of Database Workbench allows you to create the required objects for additional functionality in Database Workbench to be used with your Oracle server.

 

Currently, the only feature that requires a server side object, is the Plan Analysis in the SQL Editor.

 

If you don't choose to run the Wizard after you've registered the server, you can also reach it via the context menu on a registered Oracle server.

 

Oracle Server Context Menu

 

You can use the wizard to do 3 things:

Create the server side objects

Remove the server side objects

Create a script to create the server side objects

 

The resulting objects will be installed in their own schema, named "DBW" (short for Database Workbench).

 

Server Side Object Wizard
Starting page of the Server Side Object Wizard

 

 

Installing, upgrading or removing objects

Installing, upgrading or removing requires that you enter authentication details for a user with the following privileges:

 

create any user

drop user

create any table

select, insert, update, delete any table

grant any privilege

 

Server Side Object Wizard
Authentication Page of the Server Side Object Wizard

 

After entering the correct authentication details and selecting either Install or upgrade or the Remove option, proceed to the last page.

 

The last page will show the progress for the selection action.

 

Creating a Script for the Server Side Objects

Select the second option in the Wizard and go to the next page.

 

Server Side Object Wizard
Create Script Page of the Server Side Object Wizard

 

On the Create Scripts page, you have 3 choices on where the generated script should end up. Using the Finish button will create the script and use the target  you selected. You can use this script to create the server side objects that Database Workbench uses on multiple servers.