GET_TABLE_INDEX_DDL is a function that extracts the index DDL statements of a table in batches.
Note
This function is available from OceanBase Database V4.2.5 BP7.
Syntax
TYPE index_ddl_row IS RECORD (
index_name VARCHAR2(4000),
index_ddl CLOB
);
TYPE index_ddl_table IS TABLE OF index_ddl_row;
FUNCTION get_table_index_ddl (
table_name VARCHAR,
ob_schema VARCHAR DEFAULT NULL)
RETURN index_ddl_table PIPELINED;
Parameters
| Parameter | Description |
|---|---|
| table_name | The name of the table. |
| ob_schema | The schema that contains the table. The default value is the schema of the caller. |
Examples
Execute the following statement to extract the index DDL statements of a table in batches:
obclient> SELECT * FROM TABLE(DBMS_METADATA.GET_TABLE_INDEX_DDL(('TABLE_NAME', 'SCHEMA_NAME'));