Share this page

# Compare Oracle Environments Report

The Compare Oracle Environments report compares the data model of two Oracle schemas. The report can compare the following information:

- Functions

- Grants

- Indexes

- Packages

- Procedures

- Sequences

- Synonyms

- Tables

- Triggers

- Views

You can specify a unique filter for each category. Users can either view all objects in the category along with their associated attributes, or view only the objects and attributes that contain differences.

To run the Compare Oracle Environments report, you must first define an environment or application code for each schema in PPM. You must also have a Deployment Management license.

Table 4-4. Compare Oracle Environments report field descriptions
Field Name (*Required) | Description
--- | ---
Comparison Name | Specify a unique name for the report. Type any alphanumeric string (up to 200 characters in length).
*Reference Environment | Select a reference environment, the first environment, from the environments available on your PPM instance.
*Compared Environment | Select the second environment from the environments available on your PPM instance.
Reference AppCode | Select the application code to be used to override the parameters for the reference environment from the application codes available on your PPM instance.
Compared AppCode | Specify the application code to be used to override the parameters for the compared environment from the application codes available on your PPM instance.
Only Report Differences | Option to display only the differences between the two environments.
Compare Tables | Option to compare tables.
Table Filter | Specify a table. Type any alphanumeric string (up to 200 characters in length).
Compare Sequences | Option to compare sequences.
Sequence Filter | Specify a sequence. Type any alphanumeric string (up to 200 characters in length).
Compare Indexes | Option to compare indexes.
Index Filter | Specify an index. Type any alphanumeric string (up to 200 characters in length).
Compare Views | Option to compare views.
View Filter | Specify a view. Type any alphanumeric string (up to 200 characters in length).
Compare Packages | Option to compare packages.
Package Filter | Specify a package. Type any alphanumeric string (up to 200 characters in length).
Compare Procedures | Option to compare procedures.
Procedure Filter | Specify a procedure. Type any alphanumeric string (up to 200 characters in length).
Compare Functions | Option to compare functions.
Function Filter | Specify a function. Type any alphanumeric string (up to 200 characters in length).
Compare Triggers | Option to compare triggers.
Trigger Filter | Specify a trigger. Type any alphanumeric string (up to 200 characters in length).
Compare Synonyms | Option to compare synonyms.
Synonym Filter | Specify a synonym. Type any alphanumeric string (up to 200 characters in length).
Compare Grants | Option to compare grants.
Grant Filter | Specify a grant. Type any alphanumeric string (up to 200 characters in length).

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: