Standard Catalogs

Create and manage standard catalogs within Oracle AI Data Platform.

LiveLabs Sprint

Standard catalogs can contain external tables and volumes.

Users with the required permissions can view, modify, or create schemas, volumes, and tables inside standard catalogs. You can manage permissions to control who has access to your standard catalogs. For more information, see Standard Catalog Permissions.

When your AI Data Platform is created, it contains the default catalog. The default catalog is a standard catalog that can't be moved or renamed. Any assets you create without providing a specific location are added to the default catalog.

Create a Standard Catalog

You can create a standard catalog that connects to data in your Master Catalog.

1. Open the Create catalog in Master catalog dialog:
   • In the left navigation pane, click Create and select Catalog.
   • In the left navigation pane, click Master catalog, then click Create catalog.
2. Enter a Catalog name and Description.
3. From the Catalog type drop-down list, select Standard catalog.
4. Under Compartment (optional), click Browse and select the compartment where you want to create the bucket for your catalog.
5. Click Select.
6. Click Create.

View Standard Catalog Details

You can view the details of a standard catalog to review its configuration and metadata.

The Details tab for a standard catalog displays the catalog key and type, along with when and by whom the catalog was created and last updated.

1. In the left navigation pane, click Master catalog.
2. In the Catalogs tab, locate your catalog and click Actions, then click View.
3. Click Details.

Rename a Standard Catalog

You can rename a standard catalog if its contents or purpose has changed.

You can't rename the default catalog.

1. In the left navigation pane, click Master catalog.
2. In the Catalogs tab, locate you catalog and click Actions, then click Rename.
   
   

   

   
   
3. Edit the catalog name and press Enter.

Edit a Standard Catalog Description

You can modify the description for a standard catalog if its contents or purpose has changed.

You can't modify a description for the default catalog.

1. In the left navigation pane, click Master catalog.
2. In the Catalogs tab, locate you catalog and click Actions, then click Edit description.
   
   

   

   
   
3. Edit the catalog description and click Save.

Delete a Standard Catalog

You can delete a standard catalog when it's no longer needed.

Deleting a standard catalog deletes both the data and the stored metadata.

1. In the left navigation pane, click Master catalog.
2. In the Catalogs tab, locate you catalog and click Actions, then click Delete.
   
   

   

   
   
3. If you want to delete all the data and stored metadata associated with the catalog, select Yes, force delete all associated data and metadata.
4. Click Delete.