DBA Data[Home] [Help]

VIEW: SYS.LOGSTDBY_UNSUPPORT_TAB_12_1

Source

View Text - Preformatted

select u.name owner, o.name table_name, c.name column_name,
         c.scale, c.precision#, c.charsetform, c.type#,
   (case when bitand(t.flags, 536870912) = 536870912
         then 'Mapping table for physical rowid of IOT'
         else null end) attributes,
    (case
    /* The following are tables that are system maintained */
    when bitand(o.flags,
                2                                       /* temporary object */
              + 16                                      /* secondary object */
              + 32                                  /* in-memory temp table */
              + 128                           /* dropped table (RecycleBin) */
             ) != 0
    or bitand(t.flags,
                262144     /* 0x00040000        Summary Container Table, MV */
              + 134217728  /* 0x08000000          in-memory temporary table */
              + 536870912  /* 0x20000000  Mapping Tab for Phys rowid of IOT */
             ) != 0
    or bitand(t.property,
                512        /* 0x00000200               iot OVeRflow segment */
              + 8192       /* 0x00002000                       nested table */
              + 4194304    /* 0x00400000             global temporary table */
              + 8388608    /* 0x00800000   session-specific temporary table */
              + 33554432   /* 0x02000000        Read Only Materialized View */
              + 67108864   /* 0x04000000            Materialized View table */
              + 134217728  /* 0x08000000                    Is a Sub object */
              + 2147483648 /* 0x80000000                     eXternal TaBle */
              + 4294967296 /* 0x100000000                              Cube */
              + 8589934592 /* 0x200000000                      FBA Internal */
             ) != 0
    or bitand(t.trigflag,
                536870912  /* 0x20000000                  DDLs autofiltered */
               ) != 0
    or exists                                                /* MVLOG table */
       (select 1
        from sys.mlog$ ml where ml.mowner = u.name and ml.log = o.name)
    or exists (select 1 from sys.secobj$ so           /* ODCI storage table */
               where o.obj# = so.secobj#)
    or exists (select 1 from sys.opqtype$ opq       /* XML OR storage table */
               where o.obj# = opq.obj#
                 and bitand(opq.flags, 32) = 32)
  then -1
    /* The following tables are data tables in internal schemata *
     * that are not secondary objects                            */
  when (exists (select 1 from system.logstdby$skip_support s
                where s.name = u.name and action = 0))
  then -2
    /* The following tables are user visible tables that we choose to       *
     * skip because of some unsupported attribute of the table or column    */
  when (bitand(t.property, 1) = 1       /* 0x00000001            typed table */
    AND((bitand(t.property, 4096) = 4096) /* PK OID */
        OR exists
            (select 1
              from  sys.col$ c1
              where c1.obj# = t.obj# and
                    ((c1.type# = 58 and
 (exists (select 1 from opqtype$ opq
                   where opq.type=1
                   and bitand(opq.flags,512) = 512      /* hierarchy enabled */
                   and opq.obj#=c1.obj#
                   and opq.intcol#=c1.intcol#) or
  exists (select 1 from coltype$ ct
                   where ct.obj#=c1.obj#
                   and   ct.intcol# = c1.intcol#
                   and /* SYS.XMLTYPE */
                   ct.toid != '00000000000000000000000000020100'
                   and /* SYS.ANYDATA */
                   ct.toid != '00000000000000000000000000020011')))               /* Opaque */
                     or (c1.type# = 114)                            /* BFILE */
                        /* Non-hidden varray or varray stored in table in an */
                        /* ADT typed table.                                  */
                     or ((c1.type# = 123 and
  (bitand(c1.property, 4) = 4 or bitand(c1.property, 32)!=32)) and
                         (exists
                          (select 1 from sys.col$ c2
                             where c2.obj# = t.obj# and
                                   c2.name = 'SYS_NC_ROWINFO$' and
                                   c2.type# = 121)))
                     or (c1.type# in (58, 121, 123) and
 (exists
  (select 1 from obj$ o3, coltype$ ct3, user$ u3
    where u3.user# = o3.owner#
      and c1.obj# = ct3.obj#
      and c1.intcol# = ct3.intcol#
      and ct3.toid = o3.oid$
      and exists (select 1 from system.logstdby$skip_support sk
                   where sk.action=-5
                     and sk.name = u3.name   /* type owner */
                     and sk.name2 = o3.name  /* type name  */))))        /* Built-in */
                                       /* Nested table in an ADT typed table */
                     or (c1.type#=122 and
                         (exists
                          (select 1 from sys.col$ c2
                             where c2.obj# = t.obj# and
                                   c2.name = 'SYS_NC_ROWINFO$' and
                                   c2.type# = 121)))))))     /* 0x00020000 table is used as an AQ queue table */
     or (bitand(t.property, 131072) != 0 and
         sys_context( 'userenv', 'IS_DG_ROLLING_UPGRADE' ) = 'FALSE')  or (bitand(t.property, 4611686018427387904) != 0)
  or (bitand(t.property, 32) = 32)
    and exists (select 1 from partobj$ po
                where po.obj#=o.obj#
                and  (po.parttype in (3,             /* System partitioned */
                                      5)))        /* Reference partitioned */
  or (c.type# not in (
                  1,                             /* VARCHAR2 */
                  2,                               /* NUMBER */
                  8,                                 /* LONG */
                  12,                                /* DATE */
                  24,                            /* LONG RAW */
                  96,                                /* CHAR */
                  100,                       /* BINARY FLOAT */
                  101,                      /* BINARY DOUBLE */
                  112,                     /* CLOB and NCLOB */
                  113,                               /* BLOB */
                  180,                     /* TIMESTAMP (..) */
                  181,       /* TIMESTAMP(..) WITH TIME ZONE */
                  182,         /* INTERVAL YEAR(..) TO MONTH */
                  183,     /* INTERVAL DAY(..) TO SECOND(..) */
                  231) /* TIMESTAMP(..) WITH LOCAL TIME ZONE */
  and (c.type# != 23                      /* RAW not RAW OID */
  or  (c.type# = 23 and bitand(c.property, 2) = 2))
  and (c.type# != 58                                               /* Opaque */
  or  (c.type# = 58 and
 (exists (select 1 from opqtype$ opq
                   where opq.type=1
                   and bitand(opq.flags,512) = 512      /* hierarchy enabled */
                   and opq.obj#=c.obj#
                   and opq.intcol#=c.intcol#) or
  exists (select 1 from coltype$ ct
                   where ct.obj#=c.obj#
                   and   ct.intcol# = c.intcol#
                   and /* SYS.XMLTYPE */
                   ct.toid != '00000000000000000000000000020100'
                   and /* SYS.ANYDATA */
                   ct.toid != '00000000000000000000000000020011'))))
  and (c.type# != 121                                                 /* ADT */
  or  ( (c.type#=121 and
 (exists
   (select 1 from sys.col$ c2
     where bitand(c2.property, 32) = 32                          /* Hidden */
       and t.obj# = c2.obj#
       and c.col# = c2.col#
       and (c2.type# in (114, 122, 111) or       /* BFILE/Nested Table/REF */
           (c2.type# = 123 and
  (bitand(c2.property, 4) = 4 or bitand(c2.property, 32)!=32)) or                    /* Varray */
           (c2.type# = 58 and
 (exists (select 1 from opqtype$ opq
                   where opq.type=1
                   and bitand(opq.flags,512) = 512      /* hierarchy enabled */
                   and opq.obj#=c2.obj#
                   and opq.intcol#=c2.intcol#) or
  exists (select 1 from coltype$ ct
                   where ct.obj#=c2.obj#
                   and   ct.intcol# = c2.intcol#
                   and /* SYS.XMLTYPE */
                   ct.toid != '00000000000000000000000000020100'
                   and /* SYS.ANYDATA */
                   ct.toid != '00000000000000000000000000020011'))) or                    /* Opaque */
           (c2.type# in (58, 121, 123) and
 (exists
  (select 1 from obj$ o3, coltype$ ct3, user$ u3
    where u3.user# = o3.owner#
      and c2.obj# = ct3.obj#
      and c2.intcol# = ct3.intcol#
      and ct3.toid = o3.oid$
      and exists (select 1 from system.logstdby$skip_support sk
                   where sk.action=-5
                     and sk.name = u3.name   /* type owner */
                     and sk.name2 = o3.name  /* type name  */))))      /* Built-in type in Skip */
           )))) or
       (c.type#=121 and
       /* For non-typed tables, Primary keys on ADT attrs are disallowed.    */
       /* Primary keys should be supported on typed tables.                  */
       (bitand(t.property, 1) = 0
         and exists
         (select 1 from
           sys.ccol$ ccol, sys.col$ c2, sys.cdef$ cd
           where c.obj# = c2.obj#
             and c.obj# = cd.obj#
             and c.obj# = ccol.obj#
             and c.col# = c2.col#
             and ccol.con# = cd.con#
             and ccol.intcol# = c2.intcol#
             and bitand(c2.property, 32) = 32    /* Hidden */
             and cd.type# = 2)))))          /* Primary key */
  and (c.type# != 123                                              /* Varray */
  or (c.type# = 123 and
  (bitand(c.property, 4) = 4 or bitand(c.property, 32)!=32))))
  ----------------------------------------------------------
  /* table must have at least one scalar column to use as the id key */
  or ((c.type# in (8,24,58,112,113,121,123) or bitand(c.property, 128) = 128)
      and bitand(t.property, 1) = 0                  /* not a typed table or */
      and 0 = (select count(*) from sys.col$ c2
               where t.obj# = c2.obj#
               and bitand(c2.property, 32)  != 32              /* Not hidden */
	       and bitand(c2.property, 8)   != 8              /* Not virtual */
               and bitand(c2.property, 128) != 128      /* not stored in lob */
               and (c2.type# in ( 1,                             /* VARCHAR2 */
                                  2,                               /* NUMBER */
                                  12,                                /* DATE */
                                  23,                                 /* RAW */
                                  96,                                /* CHAR */
                                  100,                       /* BINARY FLOAT */
                                  101,                      /* BINARY DOUBLE */
                                  180,                     /* TIMESTAMP (..) */
                                  181,       /* TIMESTAMP(..) WITH TIME ZONE */
                                  182,         /* INTERVAL YEAR(..) TO MONTH */
                                  183,     /* INTERVAL DAY(..) TO SECOND(..) */
                                  231) /* TIMESTAMP(..) WITH LOCAL TIME ZONE */
      )))
  /* UNSUPPORTED BUILT-IN TYPE List:                                         */
  /* Check list of unsupported datatypes maintained in skip_support.  These  */
  /* could be built-in opaque, ADT or varray types that are singled out as   */
  /* being unsupported.                                                      */
  or (c.type# in (58, 121, 123) and
 (exists
  (select 1 from obj$ o3, coltype$ ct3, user$ u3
    where u3.user# = o3.owner#
      and c.obj# = ct3.obj#
      and c.intcol# = ct3.intcol#
      and ct3.toid = o3.oid$
      and exists (select 1 from system.logstdby$skip_support sk
                   where sk.action=-5
                     and sk.name = u3.name   /* type owner */
                     and sk.name2 = o3.name  /* type name  */))))
  /* Identity column + RNW (Replace null with) column */
  or bitand(c.property, 137438953472 + 274877906944 + 1099511627776) != 0
  ----------------------------------------------------------
  then 0 else 1 end) gensby
  from sys.obj$ o, sys.user$ u, sys.tab$ t, sys.col$ c
  where o.owner# = u.user#
  and o.obj# = t.obj#
  and o.obj# = c.obj#
  and t.obj# = o.obj#
  and bitand(c.property, 32) != 32                         /* Not hidden */
View Text - HTML Formatted

SELECT U.NAME OWNER
, O.NAME TABLE_NAME
, C.NAME COLUMN_NAME
, C.SCALE
, C.PRECISION#
, C.CHARSETFORM
, C.TYPE#
, (CASE WHEN BITAND(T.FLAGS
, 536870912) = 536870912 THEN 'MAPPING TABLE FOR PHYSICAL ROWID OF IOT' ELSE NULL END) ATTRIBUTES
, (CASE /* THE FOLLOWING ARE TABLES THAT ARE SYSTEM MAINTAINED */ WHEN BITAND(O.FLAGS
, 2 /* TEMPORARY OBJECT */ + 16 /* SECONDARY OBJECT */ + 32 /* IN-MEMORY TEMP TABLE */ + 128 /* DROPPED TABLE (RECYCLEBIN) */ ) != 0 OR BITAND(T.FLAGS
, 262144 /* 0X00040000 SUMMARY CONTAINER TABLE
, MV */ + 134217728 /* 0X08000000 IN-MEMORY TEMPORARY TABLE */ + 536870912 /* 0X20000000 MAPPING TAB FOR PHYS ROWID OF IOT */ ) != 0 OR BITAND(T.PROPERTY
, 512 /* 0X00000200 IOT OVERFLOW SEGMENT */ + 8192 /* 0X00002000 NESTED TABLE */ + 4194304 /* 0X00400000 GLOBAL TEMPORARY TABLE */ + 8388608 /* 0X00800000 SESSION-SPECIFIC TEMPORARY TABLE */ + 33554432 /* 0X02000000 READ ONLY MATERIALIZED VIEW */ + 67108864 /* 0X04000000 MATERIALIZED VIEW TABLE */ + 134217728 /* 0X08000000 IS A SUB OBJECT */ + 2147483648 /* 0X80000000 EXTERNAL TABLE */ + 4294967296 /* 0X100000000 CUBE */ + 8589934592 /* 0X200000000 FBA INTERNAL */ ) != 0 OR BITAND(T.TRIGFLAG
, 536870912 /* 0X20000000 DDLS AUTOFILTERED */ ) != 0 OR EXISTS /* MVLOG TABLE */ (SELECT 1
FROM SYS.MLOG$ ML
WHERE ML.MOWNER = U.NAME
AND ML.LOG = O.NAME) OR EXISTS (SELECT 1
FROM SYS.SECOBJ$ SO /* ODCI STORAGE TABLE */
WHERE O.OBJ# = SO.SECOBJ#) OR EXISTS (SELECT 1
FROM SYS.OPQTYPE$ OPQ /* XML OR STORAGE TABLE */
WHERE O.OBJ# = OPQ.OBJ#
AND BITAND(OPQ.FLAGS
, 32) = 32) THEN -1 /* THE FOLLOWING TABLES ARE DATA TABLES IN INTERNAL SCHEMATA * * THAT ARE NOT SECONDARY OBJECTS */ WHEN (EXISTS (SELECT 1
FROM SYSTEM.LOGSTDBY$SKIP_SUPPORT S
WHERE S.NAME = U.NAME
AND ACTION = 0)) THEN -2 /* THE FOLLOWING TABLES ARE USER VISIBLE TABLES THAT WE CHOOSE TO * * SKIP BECAUSE OF SOME UNSUPPORTED ATTRIBUTE OF THE TABLE OR COLUMN */ WHEN (BITAND(T.PROPERTY
, 1) = 1 /* 0X00000001 TYPED TABLE */ AND((BITAND(T.PROPERTY
, 4096) = 4096) /* PK OID */ OR EXISTS (SELECT 1
FROM SYS.COL$ C1
WHERE C1.OBJ# = T.OBJ# AND ((C1.TYPE# = 58 AND (EXISTS (SELECT 1
FROM OPQTYPE$ OPQ
WHERE OPQ.TYPE=1
AND BITAND(OPQ.FLAGS
, 512) = 512 /* HIERARCHY ENABLED */
AND OPQ.OBJ#=C1.OBJ#
AND OPQ.INTCOL#=C1.INTCOL#) OR EXISTS (SELECT 1
FROM COLTYPE$ CT
WHERE CT.OBJ#=C1.OBJ#
AND CT.INTCOL# = C1.INTCOL#
AND /* SYS.XMLTYPE */ CT.TOID != '00000000000000000000000000020100'
AND /* SYS.ANYDATA */ CT.TOID != '00000000000000000000000000020011'))) /* OPAQUE */ OR (C1.TYPE# = 114) /* BFILE */ /* NON-HIDDEN VARRAY OR VARRAY STORED IN TABLE IN AN */ /* ADT TYPED TABLE. */ OR ((C1.TYPE# = 123 AND (BITAND(C1.PROPERTY
, 4) = 4 OR BITAND(C1.PROPERTY
, 32)!=32)) AND (EXISTS (SELECT 1
FROM SYS.COL$ C2
WHERE C2.OBJ# = T.OBJ# AND C2.NAME = 'SYS_NC_ROWINFO$' AND C2.TYPE# = 121))) OR (C1.TYPE# IN (58
, 121
, 123) AND (EXISTS (SELECT 1
FROM OBJ$ O3
, COLTYPE$ CT3
, USER$ U3
WHERE U3.USER# = O3.OWNER#
AND C1.OBJ# = CT3.OBJ#
AND C1.INTCOL# = CT3.INTCOL#
AND CT3.TOID = O3.OID$
AND EXISTS (SELECT 1
FROM SYSTEM.LOGSTDBY$SKIP_SUPPORT SK
WHERE SK.ACTION=-5
AND SK.NAME = U3.NAME /* TYPE OWNER */
AND SK.NAME2 = O3.NAME /* TYPE NAME */)))) /* BUILT-IN */ /* NESTED TABLE IN AN ADT TYPED TABLE */ OR (C1.TYPE#=122 AND (EXISTS (SELECT 1
FROM SYS.COL$ C2
WHERE C2.OBJ# = T.OBJ# AND C2.NAME = 'SYS_NC_ROWINFO$' AND C2.TYPE# = 121))))))) /* 0X00020000 TABLE IS USED AS AN AQ QUEUE TABLE */ OR (BITAND(T.PROPERTY
, 131072) != 0 AND SYS_CONTEXT( 'USERENV'
, 'IS_DG_ROLLING_UPGRADE' ) = 'FALSE') OR (BITAND(T.PROPERTY
, 4611686018427387904) != 0) OR (BITAND(T.PROPERTY
, 32) = 32)
AND EXISTS (SELECT 1
FROM PARTOBJ$ PO
WHERE PO.OBJ#=O.OBJ#
AND (PO.PARTTYPE IN (3
, /* SYSTEM PARTITIONED */ 5))) /* REFERENCE PARTITIONED */ OR (C.TYPE# NOT IN ( 1
, /* VARCHAR2 */ 2
, /* NUMBER */ 8
, /* LONG */ 12
, /* DATE */ 24
, /* LONG RAW */ 96
, /* CHAR */ 100
, /* BINARY FLOAT */ 101
, /* BINARY DOUBLE */ 112
, /* CLOB
AND NCLOB */ 113
, /* BLOB */ 180
, /* TIMESTAMP (..) */ 181
, /* TIMESTAMP(..) WITH TIME ZONE */ 182
, /* INTERVAL YEAR(..) TO MONTH */ 183
, /* INTERVAL DAY(..) TO SECOND(..) */ 231) /* TIMESTAMP(..) WITH LOCAL TIME ZONE */
AND (C.TYPE# != 23 /* RAW NOT RAW OID */ OR (C.TYPE# = 23
AND BITAND(C.PROPERTY
, 2) = 2))
AND (C.TYPE# != 58 /* OPAQUE */ OR (C.TYPE# = 58 AND (EXISTS (SELECT 1
FROM OPQTYPE$ OPQ
WHERE OPQ.TYPE=1
AND BITAND(OPQ.FLAGS
, 512) = 512 /* HIERARCHY ENABLED */
AND OPQ.OBJ#=C.OBJ#
AND OPQ.INTCOL#=C.INTCOL#) OR EXISTS (SELECT 1
FROM COLTYPE$ CT
WHERE CT.OBJ#=C.OBJ#
AND CT.INTCOL# = C.INTCOL#
AND /* SYS.XMLTYPE */ CT.TOID != '00000000000000000000000000020100'
AND /* SYS.ANYDATA */ CT.TOID != '00000000000000000000000000020011'))))
AND (C.TYPE# != 121 /* ADT */ OR ( (C.TYPE#=121 AND (EXISTS (SELECT 1
FROM SYS.COL$ C2
WHERE BITAND(C2.PROPERTY
, 32) = 32 /* HIDDEN */
AND T.OBJ# = C2.OBJ#
AND C.COL# = C2.COL#
AND (C2.TYPE# IN (114
, 122
, 111) OR /* BFILE/NESTED TABLE/REF */ (C2.TYPE# = 123 AND (BITAND(C2.PROPERTY
, 4) = 4 OR BITAND(C2.PROPERTY
, 32)!=32)) OR /* VARRAY */ (C2.TYPE# = 58 AND (EXISTS (SELECT 1
FROM OPQTYPE$ OPQ
WHERE OPQ.TYPE=1
AND BITAND(OPQ.FLAGS
, 512) = 512 /* HIERARCHY ENABLED */
AND OPQ.OBJ#=C2.OBJ#
AND OPQ.INTCOL#=C2.INTCOL#) OR EXISTS (SELECT 1
FROM COLTYPE$ CT
WHERE CT.OBJ#=C2.OBJ#
AND CT.INTCOL# = C2.INTCOL#
AND /* SYS.XMLTYPE */ CT.TOID != '00000000000000000000000000020100'
AND /* SYS.ANYDATA */ CT.TOID != '00000000000000000000000000020011'))) OR /* OPAQUE */ (C2.TYPE# IN (58
, 121
, 123) AND (EXISTS (SELECT 1
FROM OBJ$ O3
, COLTYPE$ CT3
, USER$ U3
WHERE U3.USER# = O3.OWNER#
AND C2.OBJ# = CT3.OBJ#
AND C2.INTCOL# = CT3.INTCOL#
AND CT3.TOID = O3.OID$
AND EXISTS (SELECT 1
FROM SYSTEM.LOGSTDBY$SKIP_SUPPORT SK
WHERE SK.ACTION=-5
AND SK.NAME = U3.NAME /* TYPE OWNER */
AND SK.NAME2 = O3.NAME /* TYPE NAME */)))) /* BUILT-IN TYPE IN SKIP */ )))) OR (C.TYPE#=121 AND /* FOR NON-TYPED TABLES
, PRIMARY KEYS ON ADT ATTRS ARE DISALLOWED. */ /* PRIMARY KEYS SHOULD BE SUPPORTED ON TYPED TABLES. */ (BITAND(T.PROPERTY
, 1) = 0
AND EXISTS (SELECT 1 FROM SYS.CCOL$ CCOL
, SYS.COL$ C2
, SYS.CDEF$ CD
WHERE C.OBJ# = C2.OBJ#
AND C.OBJ# = CD.OBJ#
AND C.OBJ# = CCOL.OBJ#
AND C.COL# = C2.COL#
AND CCOL.CON# = CD.CON#
AND CCOL.INTCOL# = C2.INTCOL#
AND BITAND(C2.PROPERTY
, 32) = 32 /* HIDDEN */
AND CD.TYPE# = 2))))) /* PRIMARY KEY */
AND (C.TYPE# != 123 /* VARRAY */ OR (C.TYPE# = 123 AND (BITAND(C.PROPERTY
, 4) = 4 OR BITAND(C.PROPERTY
, 32)!=32)))) ---------------------------------------------------------- /* TABLE MUST HAVE AT LEAST ONE SCALAR COLUMN TO USE AS THE ID KEY */ OR ((C.TYPE# IN (8
, 24
, 58
, 112
, 113
, 121
, 123) OR BITAND(C.PROPERTY
, 128) = 128)
AND BITAND(T.PROPERTY
, 1) = 0 /* NOT A TYPED TABLE OR */
AND 0 = (SELECT COUNT(*)
FROM SYS.COL$ C2
WHERE T.OBJ# = C2.OBJ#
AND BITAND(C2.PROPERTY
, 32) != 32 /* NOT HIDDEN */
AND BITAND(C2.PROPERTY
, 8) != 8 /* NOT VIRTUAL */
AND BITAND(C2.PROPERTY
, 128) != 128 /* NOT STORED IN LOB */
AND (C2.TYPE# IN ( 1
, /* VARCHAR2 */ 2
, /* NUMBER */ 12
, /* DATE */ 23
, /* RAW */ 96
, /* CHAR */ 100
, /* BINARY FLOAT */ 101
, /* BINARY DOUBLE */ 180
, /* TIMESTAMP (..) */ 181
, /* TIMESTAMP(..) WITH TIME ZONE */ 182
, /* INTERVAL YEAR(..) TO MONTH */ 183
, /* INTERVAL DAY(..) TO SECOND(..) */ 231) /* TIMESTAMP(..) WITH LOCAL TIME ZONE */ ))) /* UNSUPPORTED BUILT-IN TYPE LIST: */ /* CHECK LIST OF UNSUPPORTED DATATYPES MAINTAINED IN SKIP_SUPPORT. THESE */ /* COULD BE BUILT-IN OPAQUE
, ADT OR VARRAY TYPES THAT ARE SINGLED OUT AS */ /* BEING UNSUPPORTED. */ OR (C.TYPE# IN (58
, 121
, 123) AND (EXISTS (SELECT 1
FROM OBJ$ O3
, COLTYPE$ CT3
, USER$ U3
WHERE U3.USER# = O3.OWNER#
AND C.OBJ# = CT3.OBJ#
AND C.INTCOL# = CT3.INTCOL#
AND CT3.TOID = O3.OID$
AND EXISTS (SELECT 1
FROM SYSTEM.LOGSTDBY$SKIP_SUPPORT SK
WHERE SK.ACTION=-5
AND SK.NAME = U3.NAME /* TYPE OWNER */
AND SK.NAME2 = O3.NAME /* TYPE NAME */)))) /* IDENTITY COLUMN + RNW (REPLACE NULL WITH) COLUMN */ OR BITAND(C.PROPERTY
, 137438953472 + 274877906944 + 1099511627776) != 0 ---------------------------------------------------------- THEN 0 ELSE 1 END) GENSBY
FROM SYS.OBJ$ O
, SYS.USER$ U
, SYS.TAB$ T
, SYS.COL$ C
WHERE O.OWNER# = U.USER#
AND O.OBJ# = T.OBJ#
AND O.OBJ# = C.OBJ#
AND T.OBJ# = O.OBJ#
AND BITAND(C.PROPERTY
, 32) != 32 /* NOT HIDDEN */