The DBMS_METADATA package implements the mdAPI. DBMS_METADATA allows you to generate data definition language (DDL) statements and submit 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
DBMS_METADATA 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. It calls DBMS_METADATA_INT to perform privileged features.