VIEW: SYS.KU$_10_2_TAB_COL_VIEW

Source

View Text - Preformatted

select  obj#, name, name, intcol#, col#, property,
           decode(c.property, 1056, 1, 0),   -- if nested table, 1, otherwise 0
           decode(c.property , 1056,         -- if nested table get intcol - 1
             (select name from attrcol$ a    -- else get incol info
              where a.obj# = c.obj# AND a.intcol# = c.intcol# - 1),
              (NVL((select name from attrcol$ a
                  where a.obj# = c.obj# AND a.intcol# = c.intcol#), NULL))),
           sys.dbms_metadata_util.long2varchar(c.deflength,
                                               'SYS.COL$',
                                               'DEFAULT$',
                                               c.rowid)
   from    sys.col$ c
   where   BITAND(c.property, 12) != 12 AND
          -- Need to remove rows for user defined stats.  Look in qosp.h
          -- for macros likeQOS_IS_*_STATS_EXTN.  This is where the next 3
          -- lines were taken from.
           NOT (BITAND(c.property,65576) = 65576 AND
               LENGTH(c.name) > 6 AND
               SUBSTR(c.name, 1, 6) = 'SYS_ST') AND
           --
           -- DataPump doesn't support xdp repository columns.  This foolows
           -- the same "hack" that is done in ku$_strmtable_view.  This needs
           -- to be fixed with fusion security.  Basically, 2 columns can't
           -- be imported so the stats for these 2 columns should not be
           -- exported.
           --
           NOT EXISTS (SELECT c1.obj#
                       FROM   sys.col$ c1
                       WHERE  c1.obj# = c.obj# AND
                              c1.intcol# = c.intcol# AND
                              bitand(c.property,32) != 0 AND
                              c.name IN ('OWNERID', 'ACLOID') AND
                              dbms_metadata.get_version < '12.00.00.00.00')
   order by intcol#

View Text - HTML Formatted

SELECT OBJ#
, NAME
, NAME
, INTCOL#
, COL#
, PROPERTY
, DECODE(C.PROPERTY
, 1056
, 1
, 0)
, -- IF NESTED TABLE
, 1
, OTHERWISE 0 DECODE(C.PROPERTY
, 1056
, -- IF NESTED TABLE GET INTCOL - 1 (SELECT NAME
FROM ATTRCOL$ A -- ELSE GET INCOL INFO
WHERE A.OBJ# = C.OBJ#
AND A.INTCOL# = C.INTCOL# - 1)
, (NVL((SELECT NAME
FROM ATTRCOL$ A
WHERE A.OBJ# = C.OBJ#
AND A.INTCOL# = C.INTCOL#)
, NULL)))
, SYS.DBMS_METADATA_UTIL.LONG2VARCHAR(C.DEFLENGTH
, 'SYS.COL$'
, 'DEFAULT$'
, C.ROWID)
FROM SYS.COL$ C
WHERE BITAND(C.PROPERTY
, 12) != 12 AND -- NEED TO REMOVE ROWS FOR USER DEFINED STATS. LOOK IN QOSP.H -- FOR MACROS LIKEQOS_IS_*_STATS_EXTN. THIS IS
WHERE THE NEXT 3 -- LINES WERE TAKEN FROM. NOT (BITAND(C.PROPERTY
, 65576) = 65576 AND LENGTH(C.NAME) > 6 AND SUBSTR(C.NAME
, 1
, 6) = 'SYS_ST') AND -- -- DATAPUMP DOESN'T SUPPORT XDP REPOSITORY COLUMNS. THIS FOOLOWS -- THE SAME "HACK" THAT IS DONE IN KU$_STRMTABLE_VIEW. THIS NEEDS -- TO BE FIXED WITH FUSION SECURITY. BASICALLY
, 2 COLUMNS CAN'T -- BE IMPORTED SO THE STATS FOR THESE 2 COLUMNS SHOULD NOT BE -- EXPORTED. -- NOT EXISTS (SELECT C1.OBJ#
FROM SYS.COL$ C1
WHERE C1.OBJ# = C.OBJ# AND C1.INTCOL# = C.INTCOL# AND BITAND(C.PROPERTY
, 32) != 0 AND C.NAME IN ('OWNERID'
, 'ACLOID') AND DBMS_METADATA.GET_VERSION < '12.00.00.00.00') ORDER BY INTCOL#