Introduction to the Oracle Database

A content reuse widget was here but the content was missing. The reused content is Media_Repository/Primo/Primo_VE_Doc_Note

Return to menu

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.

Primo Tablespace Information
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