Checking the Validity of an Installation

After installing your application in a deployment environment, you can check its validity using SQL Developer.

• In the Connections frame:

  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.

     The Select Connection window appears.

  4. In the Connection field, select from the menu the connection to the deployment environment.

  5. Click OK.

  6. In the Enter Bind Values window, select either Owner or Object Name.

  7. Click Apply.

     The message Displaying Results shows, followed by the results.

     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.

  8. In the Reports pane, select Invalid Objects.

  9. In the Enter Bind Values window, click Apply.

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

See Also: Oracle SQL Developer User’s Guide for more information about SQL Developer reports