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

    Installing the RPT00 Schema

    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.
      username/password:
    4. Enter the PRIMO_DBA user name and password, as follows:
      <username>/<password>
      The following response displays:

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

      idle>
      Grant succeeded.

      idle>
      Grant succeeded.

      idle>
      Grant succeeded.

             .
             .
             .

      View created.

      idle> idle> Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 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.