How to Update the Organizational Hierarchy in Oracle Projects

An organizational hierarchy lets you define logical sections of your database project, so all of your data is compartmentalized for better documentation and data integrity. The Oracle Enterprise Manager lets you create and update the hierarchy design, so you can add new groups, remove a set of data or edit a department's responsibilities. The project stores your hierarchy data in a design that you can use to organize your data.

Instructions

1. Open Enterprise Manager on your Oracle database server or a computer that can log in to the database server. Type your username and password to log in to the database server.

2. Click the project you want to edit. In the project, a list of data stores are shown, including the hierarchy data used for each organization. Click an organization and click "Edit."

3. Click the item you want to remove, if you want to remove it. Click "Delete." If you wan to change a table or data associated with the organization, click it and click "Edit."

4. Drag-and-drop each table or data column you want to use into your hierarchy data. After you finish updating the data, click "OK" to save the changes.

References

• Oracle: Organizations