SET CATALOG

Purpose

The statement switches the catalog.

Privilege requirements

To execute the SET CATALOG statement, the current user must have the USE CATALOG privilege. For more information about privileges in OceanBase Database, see Privilege types in Oracle-compatible mode.

Syntax

SET CATALOG {INTERNAL | external_catalog_name};

Parameters

Examples

• Switch to the external data catalog named test_odps_catalog.

  SET CATALOG test_odps_catalog;
  

• Switch to the system internal catalog.

  SET CATALOG INTERNAL;