Using Multiple Projects (Oracle)

There are several methods for running multiple Archibus databases at the same time.

Experienced Oracle administrators may wish to run different projects on different database servers or as different database instances on the same server.

Another method, which is the focus of this section, is to establish a separate tablespace for each project and install the projects on the same database server.

You associate the different tablespaces with different user names. With separate tablespaces, the projects have different entries in the Projects List (afm-projects.xml) file, but distinguish tablespaces when they log in. When a project uses under a particular database user name to log in for the data pool, the server will work with the tablespace that is the default for that database user name.

This section has the following topics:

Establishing Multiple Tablespaces on a Single Oracle Server

Security in Multiple Tablespaces

Creating SQL User IDs

Working with Audit Logs