All Object Reports

Use the All Object reports to view objects for the selected schema.

To view the All Object reports:

1. On the Workspace home page, click the SQL Workshop.

2. Click Utilities.

3. Click Object Reports.

   The Object Reports page appears.

4. In the All Object Reports section, select the report you want to view:

   • All Objects - List all objects in the current schema. Displays creation date and when the last DDL (data definition language) was performed.

   • Invalid Objects - View all invalid objects in the database by object type.

   • Object Creation Calendar - View all objects in a calendar format based on the date each database object was created.

   • Object Counts by Type - View the number of database objects by type for the selected schema.

   • Data Dictionary - View the data dictionary for this database.

     An Oracle data dictionary is a set of tables and views used as a read-only reference about the database. For example, a data dictionary stores information about both the logical and physical structure of the database.

     A data dictionary also stores information about valid Oracle database users, integrity constraints for tables in the database, and the amount of space allocated for a schema object and the amount being used.

5. For All reports, you can filter the report:

   1. Select an object type.

   2. Enter an object name.

   3. Click Go. See Customizing Interactive Reports in the Oracle Application Express Application Builder User's Guide for further details

6. To view reports for a different schema, select the schema from the Schema list on the upper right side of the page.