Introduction to the Oracle Database
A typical Primo installation includes a single database schema, P<r><x>_PRM00, where <r> indicates the release in which Primo was initially installed and <x> indicates the number of the installation (for example, P21_PRM00). This schema contains data and configuration information.
Oracle Users in Primo
The following are the Primo Oracle users:
-
P<r><n>_PRM00—Connects to the Oracle database (default password: P<r><n>_PRM00). This user can select, insert, update, and delete tables from the P<r><n>_PRM00 schema.
-
PRIMO_ADMIN—In addition to the privileges of the P<r><n>_PRM00 user, this user can create, delete, and alter Oracle tables, indexes, users, triggers, and so forth. The PRIMO_ADMIN user is used in all Primo procedures.
-
PRIMO_DBA—Provides access to database administration operations on the Primo system, such as startup and shutdown.
-
P<r><n>_RPT00: Provides access to the RPT00 views, which are configured from tables in PRM00. These views allow you to create your own BIRT reports, which can be viewed from the Back Office. For example, the PRIMO_BO_AUDIT_TABLE view provides access to the data regarding database activity in the Back Office. For more information on creating user-defined reports, see Creating User-Defined Reports.
-
P<r><n>_PRM00_SHARED: Used internally by the system to manage shared data for Primo Central and should not be removed.
The connection between these Oracle users and Primo servers and procedures is transparent to the end user using the Primo Front End and Back Office interfaces.
Tablespaces in Primo
An Oracle database consists of several logical units called tablespaces. Each tablespace consists of one or more physical data files that can be stored on one or more disks.
The following table shows the Primo tablespaces. Note that each tablspace may have multiple files.
| Tablespace Name | Usage | Physical File |
|---|---|---|
|
LOG
|
Oracle DB system tables
|
/exlibris/oradata/prm3/log01.dbf
|
|
SYSAUX
|
Oracle DB system tables
|
/exlibris/oradata/prm3/sysaux01.dbf
|
|
SYSTEM
|
Oracle system tables
|
/exlibris/oradata/prm3/system01.dbf
|
|
TEMP
|
Temporary space for sorting, index creation, and so forth.
|
/exlibris/oradata/prm3/temp01.dbf
|
|
TS_P_DAT
|
Primo tables
|
/exlibris/oradata/prm3/ prm3_ts_p_dat_01.dbf
|
|
TS_P_IDX
|
Primo indexes
|
/exlibris/oradata/prm3/ prm3_ts_p_idx_01.dbf
|
|
TS_ENRICH_DATA
|
PNX enrichment related content
|
/exlibris/oradata/prm3/ prm3_ts_enrich_data_01.dbf
|
|
TS_ENRICH_IDX
|
Enrichment indexes
|
/exlibris/oradata/prm3/ prm3_ts_enrich_idx_01.dbf
|
|
TS_EXL_DEF
|
Ex Libris definitions
|
/exlibris/oradata/prm3/ prm3_ts_exl_def_01.dbf
|
|
TS_PNX_ADD_DATA
|
PNX additional data
|
/exlibris/oradata/prm3/ prm3_ts_pnx_add_data_01.dbf
|
|
TS_PNX_ADD_IDX
|
PNX additional data indexes
|
/exlibris/oradata/prm3/ prm3_ts_pnx_add_idx_01.dbf
|
|
TS_PNX_DATA
|
PNX content
|
/exlibris/oradata/prm3/ prm3_ts_pnx_data_01.dbf
|
|
TS_PNX_IDX
|
PNX indexex
|
/exlibris/oradata/prm3/ prm3_ts_pnx_idx_01.dbf
|
|
TS_PNX_EXT_DATA
|
PNX extension content
|
/exlibris/oradata/prm3/ prm3_ts_pnx_ext_data_01.dbf
|
|
TS_PNX_EXT_IDX
|
PNX extension indexes
|
/exlibris/oradata/prm3/ prm3_ts_pnx_ext_idx_01.dbf
|
|
TS_SRC_REC_DATA
|
Harvested source record content
|
/exlibris/oradata/prm3/ prm3_ts_src_rec_data_01.dbf
|
|
TS_SRC_REC_IDX
|
Harvested source record indexes
|
/exlibris/oradata/prm3/ prm3_ts_src_rec_idx_01.dbf
|
|
TS_STATS_DATA
|
Primo application statistics content
|
/exlibris/oradata/prm3/ prm3_ts_stats_data_01.dbf
|
|
TS_STATS_IDX
|
Primo application statistics indexes
|
/exlibris/oradata/prm3/ prm3_ts_stats_idx_01.dbf
|
|
TSLOB
|
Oracle DB system tables
|
/exlibris/oradata/prm3/tslob01.dbf
|
|
UNDOTBS1
|
Oracle DB system tables
|
/exlibris/oradata/prm3/undotbs101.dbf
|
|
USERS
|
Oracle DB system tables
|
/exlibris/oradata/prm3/users01.dbf
|