Comparison of configuration scenarios

Characteristic	Single database instance (SameDB)	Different database instance (DiffDB)
Oracle Streams	Oracle Streams is not required, because there is no need to replicate study data.	Oracle Streams is required. When you install the Reporting and Analysis module into a different database from the study, data is replicated using Oracle Streams. For more information about streams, streams operations, and monitoring, see the Oracle database documentation about streams.
Schema ownership	The study schema owner owns all study and reporting objects.	Different schema owners own study or reporting objects (and each schema is in a separate instance).
Archive log mode	Running in archive log mode is not required.	Running in archive log mode is required. For more information, the Installation Guide.

Characteristic

Single database instance
(SameDB)

Different database instance
(DiffDB)

Oracle Streams

Oracle Streams is not required, because there is no need to replicate study data.

Oracle Streams is required.

When you install the Reporting and Analysis module into a different database from the study, data is replicated using Oracle Streams.

For more information about streams, streams operations, and monitoring, see the Oracle database documentation about streams.

Schema ownership

The study schema owner owns all study and reporting objects.

Different schema owners own study or reporting objects (and each schema is in a separate instance).

Archive log mode

Running in archive log mode is not required.

Running in archive log mode is required.

For more information, the Installation Guide.