VIEW: SYS.KU$_TAB_COMPART_VIEW

Source

View Text - Preformatted

select tcp.obj#, value(o), tcp.dataobj#, tcp.bo#,
         dbms_metadata.get_partn(2,tcp.bo#,tcp.part#),
         tcp.hiboundlen,
         sys.dbms_metadata_util.long2varchar(tcp.hiboundlen,
                                    'SYS.TABCOMPART$',
                                    'HIBOUNDVAL',
                                    tcp.rowid),
         tcp.subpartcnt,
         sys.dbms_metadata.check_match_template_par(tcp.obj#, tcp.subpartcnt),
         cast(multiset(select * from ku$_tab_subpart_view tsp
                       where tsp.pobj_num = tcp.obj#
                       order by tsp.subpart_num
                      ) as ku$_tab_subpart_list_t
                  ),
         sys.dbms_metadata.check_match_template_lob(tcp.obj#, tcp.subpartcnt),
         cast(multiset(select * from ku$_lobcomppart_view lc
                       where lc.part_obj_num = tcp.obj#
                        order by lc.intcol_num
                      ) as ku$_lobcomppart_list_t
                  ),
         tcp.flags, ts.name, ts.blocksize,
         tcp.defpctfree, tcp.defpctused, tcp.definitrans,
         tcp.defmaxtrans, tcp.definiexts, tcp.defextsize, tcp.defminexts,
         tcp.defmaxexts, tcp.defextpct, tcp.deflists, tcp.defgroups,
         tcp.deflogging, tcp.defbufpool, to_char(tcp.analyzetime,'YYYY/MM/DD HH24:MI:SS'), tcp.samplesize,
         tcp.rowcnt, tcp.blkcnt, tcp.empcnt, tcp.avgspc, tcp.chncnt,
         tcp.avgrln, tcp.spare1,
         -- Convert 'spare2' to a value that the pre-11.2 xsl stylesheet
         -- can process: if archive compressed and version < 11.2,
         -- turn off compression.  The block format for archive compression
         -- is not supported pre-11.2, so the compression bits must be
         -- set to NOCOMPRESS.
         case when bitand(tcp.spare2,8+16+32+64)=0 then tcp.spare2
              when dbms_metadata.get_version >= '11.02.00.00.00'
                   then tcp.spare2
              else 2
         end,
         tcp.spare3, tcp.defmaxsize,
         tcp.bhiboundval
  from ku$_schemaobj_view o, tabcompart$ tcp, ts$ ts
  where tcp.obj# = o.obj_num
        AND tcp.defts# = ts.ts#

View Text - HTML Formatted

SELECT TCP.OBJ#
, VALUE(O)
, TCP.DATAOBJ#
, TCP.BO#
, DBMS_METADATA.GET_PARTN(2
, TCP.BO#
, TCP.PART#)
, TCP.HIBOUNDLEN
, SYS.DBMS_METADATA_UTIL.LONG2VARCHAR(TCP.HIBOUNDLEN
, 'SYS.TABCOMPART$'
, 'HIBOUNDVAL'
, TCP.ROWID)
, TCP.SUBPARTCNT
, SYS.DBMS_METADATA.CHECK_MATCH_TEMPLATE_PAR(TCP.OBJ#
, TCP.SUBPARTCNT)
, CAST(MULTISET(SELECT *
FROM KU$_TAB_SUBPART_VIEW TSP
WHERE TSP.POBJ_NUM = TCP.OBJ# ORDER BY TSP.SUBPART_NUM ) AS KU$_TAB_SUBPART_LIST_T )
, SYS.DBMS_METADATA.CHECK_MATCH_TEMPLATE_LOB(TCP.OBJ#
, TCP.SUBPARTCNT)
, CAST(MULTISET(SELECT *
FROM KU$_LOBCOMPPART_VIEW LC
WHERE LC.PART_OBJ_NUM = TCP.OBJ# ORDER BY LC.INTCOL_NUM ) AS KU$_LOBCOMPPART_LIST_T )
, TCP.FLAGS
, TS.NAME
, TS.BLOCKSIZE
, TCP.DEFPCTFREE
, TCP.DEFPCTUSED
, TCP.DEFINITRANS
, TCP.DEFMAXTRANS
, TCP.DEFINIEXTS
, TCP.DEFEXTSIZE
, TCP.DEFMINEXTS
, TCP.DEFMAXEXTS
, TCP.DEFEXTPCT
, TCP.DEFLISTS
, TCP.DEFGROUPS
, TCP.DEFLOGGING
, TCP.DEFBUFPOOL
, TO_CHAR(TCP.ANALYZETIME
, 'YYYY/MM/DD HH24:MI:SS')
, TCP.SAMPLESIZE
, TCP.ROWCNT
, TCP.BLKCNT
, TCP.EMPCNT
, TCP.AVGSPC
, TCP.CHNCNT
, TCP.AVGRLN
, TCP.SPARE1
, -- CONVERT 'SPARE2' TO A VALUE THAT THE PRE-11.2 XSL STYLESHEET -- CAN PROCESS: IF ARCHIVE COMPRESSED
AND VERSION < 11.2
, -- TURN OFF COMPRESSION. THE BLOCK FORMAT FOR ARCHIVE COMPRESSION -- IS NOT SUPPORTED PRE-11.2
, SO THE COMPRESSION BITS MUST BE -- SET TO NOCOMPRESS. CASE WHEN BITAND(TCP.SPARE2
, 8+16+32+64)=0 THEN TCP.SPARE2 WHEN DBMS_METADATA.GET_VERSION >= '11.02.00.00.00' THEN TCP.SPARE2 ELSE 2 END
, TCP.SPARE3
, TCP.DEFMAXSIZE
, TCP.BHIBOUNDVAL
FROM KU$_SCHEMAOBJ_VIEW O
, TABCOMPART$ TCP
, TS$ TS
WHERE TCP.OBJ# = O.OBJ_NUM
AND TCP.DEFTS# = TS.TS#