Oracle Usage Notes

If you use Archibus with the Oracle database, please be aware of the following usage notes.

• Delete Table Command .  If you delete a table that has child records, you will get an SQL error since the records are deleted in bulk, and the bulk change does not cascade.
• Replace Column .  You should use the Replace Column command only in views that do not contain a table in the Standard role.
• With the Oracle server, you cannot use the Replace Column command on a view that has both a standard table and a restriction. For example, suppose you have loaded the “Rooms” view, which presents a single table-group, composed of the Rooms table in the assigned role and the Room Standards table in the standard role. You can use the Replace Column command in this view--but only provided you do not have a restriction active.
• The underlying reason for this is that Oracle does not allow multiple tables in its update statement; and the Archibus Replace Column command always includes both the assigned and standard tables in the update statement if a restriction is present, because the restriction may relate the two tables.
• If you wish to use Replace Column in a situation like the restricted Rooms table, load the Rooms table in a view that presents the Rooms table in its own table-group. You can do so, for instance, by using the New View command, which quickly creates a view of the Rooms table without any related tables.