DBA_STAT_EXTENSIONS
仕様
PROD(JASON)> select * from v$version;

BANNER
------------------------------------------------------------------------------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - Production
PL/SQL Release 11.1.0.7.0 - Production
CORE    11.1.0.7.0      Production
TNS for Linux: Version 11.1.0.7.0 - Production
NLSRTL Version 11.1.0.7.0 - Production

経過: 00:00:00.02
PROD(JASON)> desc DBA_STAT_EXTENSIONS
 名前                                                                              NULL?    型
 ----------------------------------------------------------------------------------- -------- --------------------------------------------------------
 OWNER                                                                               NOT NULL VARCHAR2(30)
 TABLE_NAME                                                                          NOT NULL VARCHAR2(30)
 EXTENSION_NAME                                                                      NOT NULL VARCHAR2(30)
 EXTENSION                                                                                    CLOB
 CREATOR                                                                                      VARCHAR2(6)
 DROPPABLE                                                                                    VARCHAR2(3)

PROD(JASON)>
用例
PROD(JASON)> col EXTENSION_NAME format a40
PROD(JASON)> col EXTENSION format a60
PROD(JASON)> select extension_name, extension from user_stat_extensions where table_name='T_OBJ';

EXTENSION_NAME                           EXTENSION
---------------------------------------- ------------------------------------------------------------
SYS_STUXJ8K0YTS_5QD1O0PEA514IY           ("OWNER","OBJECT_TYPE")

経過: 00:00:00.02
PROD(JASON)>
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License