Checking the Validity of an Installation

After installing your application in a deployment environment, you can check its validity in the following ways in SQL Developer:

• In the Connections pane:

  1. Expand the connection to the deployment environment.

  2. Examine the definitions of the new objects.

• In the Reports pane:

  1. Expand Data Dictionary Reports.

     A list of data dictionary reports appears.

  2. Expand All Objects.

     A list of objects reports appears.

  3. Select All Objects.

  4. Click the icon Run Report.

     The Enter Bind Values window appears.

  5. Select either Owner or Object.

  6. Click Apply.

     The message "Executing Report" shows, followed by the report itself.

     For each object, this report lists the Owner, Object Type, Object Name, Status (Valid or Invalid), Date Created, and Last DDL. Last DDL is the date of the last DDL operation that affected the object.

  7. Select Invalid Objects.

     The Enter Bind Values window appears.

  8. Click Apply.

     The message "Executing Report" shows, followed by the report itself.

     For each object whose Status is Invalid, this report lists the Owner, Object Type, and Object Name.