The DBMS_METADATA package generates DDL statements and submits XML files to execute DDL statements.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Privileges
This system package is owned by the SYS user and has privileges granted to PUBLIC. DBMS_METADATA is executed with the privileges of the caller, that is, based on the security profile of the caller.
Overview of DBMS_METADATA procedures
The following table lists the DBMS_METADATA procedures supported in the current OceanBase Database version and their brief descriptions.
| Procedure | Description |
|---|---|
| GET_DDL | Returns the metadata of a single object as DDL. |
| GET_TABLE_INDEX_DDL | Extracts the index DDL statements for the primary table (TABLE) in batches. |