Updating Projects (Oracle)

Periodically, new versions of the database schema are released with new revisions of the Archibus software. When this occurs, you can update your project data using Archibus Database Update Wizard, or using Oracle's Database Administration Tools.

Database Update Wizard

Archibus ships with the Database Update Wizard, a utility that can migrate Archibus data and schema between projects--regardless of whether those projects are on Oracle or Microsoft SQL Server. Refer to Database Update Wizard: Overview for information.

Oracle Database Administration Tools

Oracle users may prefer instead to use the Oracle database administration tools to perform this kind of database reconfiguration. To do this, your Oracle DBA can use the following process:

  1. Back up your database.
  2. Perform a table-mode export of those tables for which you have data, for instance:

exp userid=afm/<password> tables=(bl,fl,rm,dp,dv,rmstd,rmcat,rmtype

  1. Use databases\oracle\schema\afmoscm_drop.sql to drop your Archibus database.
  2. Import the blank AfmoScm.dmp file using the \databases\oracle\schema\AfmoScm9.bat file.
  3. Import your table data using Imp.exe . A typical import might be:

Imp userid=afm/<password> tables=(bl,fl,rm,dp,dv,rmstd,rmcat,rmtype)

As an alternative, you can use the Oracle Data Manager to perform the export and import. The Oracle Data Manager has options to export and import all of the tables in your database at one time.