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.
DBMS_METADATA 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.
DBMS_METADATA subprograms
The following table lists the DBMS_METADATA subprograms supported in the current version of OceanBase Database and their brief descriptions. Subprogram | Description | | --- | --- | |GET_DDL|Returns the metadata of a single object as DDL.| |GET_TABLE_INDEX_DDL|Extracts the index DDL statements of the main table (TABLE) in batches.|