Installing the RPT00 Schema

Last updated
Save as PDF
Share
1. Share
2. Tweet
3. Share

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:

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
Enter option 21. The following prompt displays:

Do you want to create/recreate Oracle reports (RPT00) schema? yes/[no]
Enter yes to continue. The following prompt displays:

To continue you will need to enter PRIMO_DBA username/password.

username/password:
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.
Press Enter to exit the utility.