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:
-
Enter the following commands to display the Managing Oracle menu:dlib prm00util oO. 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 SchemaThe RPT00 schema does not require additional disk space. -
Press Enter to exit the utility.