Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Installing the RPT00 Schema

    This information is not applicable to Primo VE environments. For more details on Primo VE configuration, see Primo VE.
    In order to create the Primo Reporting Schema (RTP00), you must run UTIL O from the Back Office server.
    In Primo V3 and later releases, the RTP00 schema is created automatically for new installations.
    In addition to the RPT00 views, this utility creates the p<r><c>_RPT00 user, which is needed to connect to the RPT00 views from the BIRT Report Designer. For more information on connecting with BIRT, see Installing User-Defined Reports.
    This operation needs to be run only once to build the RPT00 schema.
    To create the RPT00 schema:
    1. Enter the following commands to display the Managing Oracle menu:
      dlib prm00
      util o
           O. Managing ORACLE
               0.  Exit Procedure
               1.  Oracle Server
               2.  Oracle Listener
               3.  Oracle Logs
               4.  Resumable Space Allocation
               6.  Nls
               7.  Archiving
               9.  Database Users
              10.  SQL*Plus Session
              11.  Oracle user password utility
              12.  Database Verification Utility
              13.  Database Files
              14.  Database Free/Used Space
              16.  Database Links
              17.  Database Tablespaces
              18.  Oracle Statistics
              19.  Shared Pool
              20.  Multi Threaded Server
              21.  Create/Recreate reports(RPT00) schema
      Please select [exit]:
      Managing Oracle Menu
    2. Enter option 21. The following prompt displays:
      Do you want to create/recreate Oracle reports (RPT00) schema? yes/[no]
    3. Enter yes to continue. The following prompt displays:
      To continue you will need to enter PRIMO_DBA username/password.
    4. Enter the PRIMO_DBA user name and password, as follows:
      The following response displays:

      To continue you will need to enter PRIMO_DBA username/password.
      username/password: Creating P21_RPT00 user
      SQL*Plus: Release - Production on Wed Jan 21 21:32:17 2009
      Copyright (c) 1982, 2005, Oracle.  All rights reserved.
      idle> Connected.
      User created.

      Grant succeeded.

      Grant succeeded.

      Grant succeeded.


      View created.

      idle> idle> Disconnected from Oracle Database 10g Enterprise Edition Release - Production
      With the Partitioning, OLAP and Data Mining Scoring Engine options
      Success to create reports(RPT00) schema
      Enter CR to continue...

      Example Response for Create Report Schema
      The RPT00 schema does not require additional disk space.
    5. Press Enter to exit the utility.