About the Catalog Page
Use the Catalog page to 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 Analytic Views, cloud storage links, and tables that are created by Database Actions applications such as Data Analysis and Data Load.
-
Database data dictionary objects such as tables, columns, database links, analytic views, packages, and procedures that have been created by the database tools or a database application such as SQL Developer.
When you first open the Browse catalog page, it contains the Search catalog field, the Show User Preferences button, 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
The Catalog page contains:
-
Search catalog field
You can search for the entities in the search field. For more details see Browse and Search Catalogs.
- Schema
You can search for all the entities available in the other catalog schemas listed here.
-
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.
-
Catalog User Preferences
Click Catalog User Preferences
to set the behavior of the Catalog. When you set these options, they take place immediately and are also saved as the default behavior for the page. Clicking Show User Preferences opens the General tab where you can view the following options.
-
Show system tables
Select this option to include system tables in the search results.
-
Show private tables
Select this option to include private tables in the search results.
-
Page size
Select the number of entities to display on the page.
-
Gradually progress to use the Query Scopes tab to view, create, and delete query scopes. You can search for catalogs and save this search using query scopes.
Selecting Query Scope icon prompts a Catalog User Preferences wizard which enables you to save your catalogs based on your preferences.
You can view, create, and edit the previously saved query scopes in this wizard. The query scopes are categorized based on by whom its created.
- Select Custom to view, create, edit, or delete the query scopes created by you.
- Select Predefined to view the query scopes which are already defined by the Database Actions. This option does not allow you to create, edit, or delete the query scopes.
- Select All to view all the query scopes. This includes Custom and Predefined query scopes.
Specify the following fields in the Query Scope tab.
- Name: Enter the name of the Query Scope. This is a mandatory field.
- Label: This is a mandatory field. Enter a descriptive name here. You will use this field to refer to a query scope.
- Definition: Enter the Oracle Autonomous Database Data Definition Language (DDL) that creates the search entity. This is the same search criteria you enter in the Search Catalog field.
Click Create to create the Query Scope. Click Cancel to cancel its creation.
Once you have created the new query scope, it is visible in the list of query scopes in the Catalog User Preferences wizard. Click New to create a new query scope
Progress to the Saved Searches tab
Select this tab to save the five previous search queries that you entered into the Search catalog field. When the Search catalog field is empty and you click in the field, the last five search queries are listed in the drop-down list. (Any predefined searches selected from the Suggestions panel won't appear in this list, unless you edited them to make a new search.)
Click on the Saved Searches tab to save the current search query as per the criteria you specify or create a new saved search.
- Progress to the Customize Theme tab to expand each entity type to select the properties and preview it.
-
-
Saved Search Suggestions
Click to open or close the Saved Search Suggestions panel.
- 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 one or more of the sorting values. For example, if you select the Ascending icon next to Entity name and the Descending icon next to Entity type, the entities will be sorted in alphabetical order by entity name and then in reverse alphabetical order by entity type.
Click Reset in the list to clear the choices in the list.
The sorting values you choose are listed next to the Sort by label beneath the toolbar. Click the X icon on a sorting value to remove it.
-
-
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.
Create a saved search
You can save your time from redefining the same search again in the future. You can diagnose problems faster since you are just few clicks away from accessing a saved search. Here is how you can create a saved search. Ensure the Advanced search toggle is on.
- From the Saved Searches tab of the Catalog User Preferences , click Add.
- Specify the Title, Scope, Definition and Description (optional field) in their respective fields. For example, you want to search for a specific Entity type and a specific owner.
- Select Save.
After the creation of the saved search, it appears on the list of Saved Searches.
You can change the columns displayed in the search results by clicking the pencil icon in the Actions column. Click the delete icon in the Actions column to delete the search you save. The saved searches you create are available for selection in the Saved Search panel in the right of the Catalog page.
Click New to create a new saved search.