分区索引（一）(二)

-dba_ind_partitions

SQL> select index_name,partition_name, status from  dba_ind_partitions  where index_name='I_ID_GLOBAL';

INDEX_NAME                     PARTITION_NAME                 STATUS

------------------------------ ------------------------------ --------

I_ID_GLOBAL                    P1                             USABLE

I_ID_GLOBAL                    P2                             USABLE

I_ID_GLOBAL                    P3                             USABLE

I_ID_GLOBAL                    P4                             USABLE

--dba_ind_partitions

set linesize 230

col column_name format a30

SQL> select table_name,index_name,column_name from dba_ind_columns where table_name='PDBA' and table_owner='SYS';



TABLE_NAME                     INDEX_NAME                     COLUMN_NAME

------------------------------ ------------------------------ ------------------------------

PDBA                           I_ID_GLOBAL                    ID

 --dba_indexes

SQL> select  owner,index_name,table_name,status  from  dba_indexes  where INDEX_NAME='I_ID_GLOBAL';

OWNER                          INDEX_NAME                     TABLE_NAME                     STATUS

------------------------------ ------------------------------ ------------------------------ --------

SYS                            I_ID_GLOBAL                    PDBA                           N/A