VIEW: SYS.KU$_CLUSTER_VIEW

Source

View Text - Preformatted

select '1','3',
        o.obj_num,
        value(o),
        cast(multiset(select * from ku$_column_view col
                       where col.obj_num = c.obj#
                        order by col.col_num, col.intcol_num
                      ) as ku$_column_list_t
        ),
        ts.name, ts.blocksize,
        ts.ts#, c.file#, c.block#,
        c.pctfree$, c.pctused$, c.initrans, c.maxtrans,NVL(c.size$, -1),
        c.hashfunc, NVL(c.hashkeys, 0), NVL(c.func, 1), c.extind,
        c.flags,
        NVL(c.degree, 1), NVL(c.instances, 1),
        NVL(c.avgchn, -1),
        (select condlength from sys.cdef$ co  where co.obj# = c.obj#),
        NULL,    /* functxt  */
        NULL,    /* func_vcnt */
        (select sys.dbms_metadata_util.long2clob(cd.condlength,
                                        'SYS.CDEF$',
                                        'CONDITION',
                                        cd.rowid)
              from sys.cdef$ cd  where cd.obj# = c.obj#),
        (select value(s) from  ku$_storage_view s
             where s.file_num = c.file#  and  s.block_num= c.block#
                 and s.ts_num = c.ts#),
        c.spare1, c.spare2, c.spare3, c.spare4, c.spare5, c.spare6,
        to_char(c.spare7,'YYYY/MM/DD HH24:MI:SS')
   from     sys.ku$_schemaobj_view o, sys.ts$ ts, sys.clu$ c
   where    o.obj_num = c.obj# AND
                c.ts# = ts.ts# AND
            (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (o.owner_num, 0) OR
             EXISTS ( SELECT * FROM sys.session_roles
                WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '3'
, O.OBJ_NUM
, VALUE(O)
, CAST(MULTISET(SELECT *
FROM KU$_COLUMN_VIEW COL
WHERE COL.OBJ_NUM = C.OBJ# ORDER BY COL.COL_NUM
, COL.INTCOL_NUM ) AS KU$_COLUMN_LIST_T )
, TS.NAME
, TS.BLOCKSIZE
, TS.TS#
, C.FILE#
, C.BLOCK#
, C.PCTFREE$
, C.PCTUSED$
, C.INITRANS
, C.MAXTRANS
, NVL(C.SIZE$
, -1)
, C.HASHFUNC
, NVL(C.HASHKEYS
, 0)
, NVL(C.FUNC
, 1)
, C.EXTIND
, C.FLAGS
, NVL(C.DEGREE
, 1)
, NVL(C.INSTANCES
, 1)
, NVL(C.AVGCHN
, -1)
, (SELECT CONDLENGTH
FROM SYS.CDEF$ CO
WHERE CO.OBJ# = C.OBJ#)
, NULL
, /* FUNCTXT */ NULL
, /* FUNC_VCNT */ (SELECT SYS.DBMS_METADATA_UTIL.LONG2CLOB(CD.CONDLENGTH
, 'SYS.CDEF$'
, 'CONDITION'
, CD.ROWID)
FROM SYS.CDEF$ CD
WHERE CD.OBJ# = C.OBJ#)
, (SELECT VALUE(S)
FROM KU$_STORAGE_VIEW S
WHERE S.FILE_NUM = C.FILE#
AND S.BLOCK_NUM= C.BLOCK#
AND S.TS_NUM = C.TS#)
, C.SPARE1
, C.SPARE2
, C.SPARE3
, C.SPARE4
, C.SPARE5
, C.SPARE6
, TO_CHAR(C.SPARE7
, 'YYYY/MM/DD HH24:MI:SS')
FROM SYS.KU$_SCHEMAOBJ_VIEW O
, SYS.TS$ TS
, SYS.CLU$ C
WHERE O.OBJ_NUM = C.OBJ# AND C.TS# = TS.TS# AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))