Use the Catalog Tool to browse, search and discover data either in your Oracle Autonomous Database, or connected to it and get information about the entities in and available to your Oracle Autonomous Database. You can see the data in an entity, the sources of that data, the objects that are derived from the entity, and the impact on derived objects from changes in the sources.

The Catalog page lists and displays details about:

• Database objects such as tables, columns, views, cloud objects, analytic views, packages, procedures, shares, share recipients, catalogs, catalog storage links, live table feed, share providers.

• Other types of object connected to the database, such as Cloud Storage Links, Cloud Storage Buckets, Cloud Objects (files on connected Cloud Storage), Compartments, Data Catalog Links, Catalog Storage Links, Autonomous Database.

• Database data dictionary objects such as tables, columns, views, database links, analytic views, packages, and procedures that have been created by the database tools or a database application such as SQL Developer.

Catalog Tool Terminology

A Local catalog is all the objects in or directly connected to your Autonomous Database as described in the above points. In addition to the local catalog, Catalog Explorer can add in additional catalogs so that you can discover data from other sources.

Once a new catalog has been mounted, you can add the catalog in the Catalog tool, and search and discover data from that catalog, or across many catalogs.

When you first open the Browse catalog page, it contains the Search catalog field, the Catalog Settings button, Manage Catalogs icon, a list of recently viewed objects, and several suggested searches. You can enter a search string, click on one of the recent objects to see its details, or click on Show search suggestions icon to view suggestions on the right side of the page.

As soon as you select Catalog menu from Data Studio menu bar, the page is displayed as below.

Description of the illustration catalog-fix.png

When you hover your mouse over a particular catalog entity, it will show a floating toolbar of common actions. The list is context-sensitive depending on the capabilities available for the particular entity. For example, tables in the current database offer more possibilities than tables in remote catalogs.

The Catalog page contains:

1. Search field

   You can search for the entities in the search field. For more details see Browse and Search Catalogs.

2. Select Catalogs... field

   Clicking this icon opens the Catalogs and Schemas dialog box.

   You can view a list of all mounted catalogs and schemas in this dialog box.

   Select specific schemas from a database of your choice to refine your search.

   • To show tables of only the AA schema from PHOENIX database, in addition to the default local schema:
     • On the Catalogs and Schemas dialog box, click the PHOENIX database and select AA from the Select Schemas search field.
       
       
       
       Description of the illustration catalogs-schemas.png
       
       
3. Default Database name and Schema name

   This field displays the default database name along with the schema name.

4. Manage Catalogs

   Refer to Manage Catalogs for detailed information.

5. Catalog Settings

   Refer to Catalog Settings for detailed information.

6. Saved Search Suggestions

   Click to open or close the Saved Search Suggestions panel.

7. Filters option

   Click any of the filters icon to filter and refine the search results.

   Refer to Browse and Search Catalogs for detailed information.

8. Display area

   The area beneath the Search catalog field displays the entities returned by a search and that match the filter criteria set in the Filters panel. You can sort the entities by clicking the Sort By button and then setting sort values.

   Hover besides the name of the entity to view details about the entity.

9. Faceted Filters panel

   Select one or more filter values to limit the entities shown on the page. Only those entities that match the filter values are shown. That is, the items returned by a search are filtered by these filter settings. The filters also change depending on the quick filters you select. See Filter Entities.

10. Toolbar

    The toolbar appears after you run an initial search. It contains these buttons:

    • Sort By

      To select sorting values, click the Sort By button to open the list of options. Then click the Ascending or Descending icon next to Name or Updated. For example, if you select the Ascending icon next to Name the entities will be sorted in alphabetical order by entity name. If you select Descending icon next to Updated, the entities will be sorted in reverse of the latest updated entity..

      Click Reload to refresh the choices in the list.