如何查看索引的定义，以及查看该索引究竟是全局索引还是非全局索引

obclient> select dbms_metadata.get_ddl('INDEX','GINDEX') from dual;

+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| DBMS_METADATA.GET_DDL('INDEX','GINDEX')|
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| CREATE INDEX "ORA_POC"."GINDEX" on "ORA_POC"."T1" (
    "B"
  ) GLOBAL
  partition by range(b)
  (partition P0 values less than (1),
  partition P1 values less than (2),
  partition P2 values less than (3));
|
+-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.228 sec)

obclient [mysql]> show create table test;

+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table  | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              |
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| test01 | CREATE TABLE `test` (
  `col1` int(11) DEFAULT NULL,
  `col2` int(11) DEFAULT NULL,
  KEY `idx_col1_test` (`col1`) BLOCK_SIZE 16384 GLOBAL
) DEFAULT CHARSET = utf8mb4 ROW_FORMAT = DYNAMIC COMPRESSION = 'zstd_1.3.8' REPLICA_NUM = 1 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0
 partition by range(col1) subpartition by list(col2)
(partition p0 values less than (100) (
subpartition sp0 values in (1,3),
subpartition sp1 values in (4,6),
subpartition sp2 values in (7,9)),
partition p1 values less than (200) (
subpartition sp3 values in (1,3),
subpartition sp4 values in (4,6),
subpartition sp5 values in (7,9))) |
+--------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.003 sec)