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).