[Home] [Help]
select u.name owner, o.name name, o.type#, o.obj#,
decode(bitand(t.flags, 1073741824), 1073741824, 1, 0) current_sby,
(case
/* The following are tables that are system maintained */
when ( exists (select 1 from system.logstdby$skip_support s
where s.name = u.name and action = 0))
or 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 (select 1 from sys.mlog$ ml /* MVLOG table */
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 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)))))))
/* Table has a Temporal Validity column */
or (bitand(t.property, 4611686018427387904) != 0)
or (bitand(t.property, 32) = 32) /* Partitioned */
and exists (select 1 from partobj$ po
where po.obj#=o.obj#
and (po.parttype in (3, /* System partitioned */
5))) /* Reference partitioned */
or bitand(t.property,
/* This clause is only for performance; they could be
excluded by the column datatype checks below. */
32768 /* 0x00008000 has FILE columns */
) != 0
/* AQ Queue tables are not supported, unless we are in rolling upgrade */
or (bitand(t.property, 131072) != 0 and
sys_context( 'userenv', 'IS_DG_ROLLING_UPGRADE' ) = 'FALSE')
-----------------------------------------
/* unsupp view joins col$, here we subquery it */
or exists (select 1 from sys.col$ c
where t.obj# = c.obj#
-----------------------------------------
/* ignore any hidden columns in this subquery */
and bitand(c.property, 32) != 32 /* Not hidden */
-----------------------------------------
/* table has an unsupported datatype */
and ((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. Pkeys 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 doesnt have at least one scalar column */
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)
) /* end col$ exists subquery */
----------------------------------------------
then 0 else 1 end) gensby
from sys.obj$ o, sys.user$ u, sys.tab$ t
where o.owner# = u.user#
and o.obj# = t.obj#
and t.obj# = o.obj#
SELECT U.NAME OWNER
, O.NAME NAME
, O.TYPE#
, O.OBJ#
,
DECODE(BITAND(T.FLAGS
, 1073741824)
, 1073741824
, 1
, 0) CURRENT_SBY
,
(CASE
/* THE FOLLOWING ARE TABLES THAT ARE SYSTEM MAINTAINED */
WHEN ( EXISTS (SELECT 1
FROM SYSTEM.LOGSTDBY$SKIP_SUPPORT S
WHERE S.NAME = U.NAME
AND ACTION = 0))
OR 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 (SELECT 1
FROM SYS.MLOG$ ML /* MVLOG TABLE */
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 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)))))))
/* TABLE HAS A TEMPORAL VALIDITY COLUMN */
OR (BITAND(T.PROPERTY
, 4611686018427387904) != 0)
OR (BITAND(T.PROPERTY
, 32) = 32) /* PARTITIONED */
AND EXISTS (SELECT 1
FROM PARTOBJ$ PO
WHERE PO.OBJ#=O.OBJ#
AND (PO.PARTTYPE IN (3
, /* SYSTEM PARTITIONED */
5))) /* REFERENCE PARTITIONED */
OR BITAND(T.PROPERTY
,
/* THIS CLAUSE IS ONLY FOR PERFORMANCE; THEY COULD BE
EXCLUDED BY THE COLUMN DATATYPE CHECKS BELOW. */
32768 /* 0X00008000 HAS FILE COLUMNS */
) != 0
/* AQ QUEUE TABLES ARE NOT SUPPORTED
, UNLESS WE ARE IN ROLLING UPGRADE */
OR (BITAND(T.PROPERTY
, 131072) != 0 AND
SYS_CONTEXT( 'USERENV'
, 'IS_DG_ROLLING_UPGRADE' ) = 'FALSE')
-----------------------------------------
/* UNSUPP VIEW JOINS COL$
, HERE WE SUBQUERY IT */
OR EXISTS (SELECT 1
FROM SYS.COL$ C
WHERE T.OBJ# = C.OBJ#
-----------------------------------------
/* IGNORE ANY HIDDEN COLUMNS IN THIS SUBQUERY */
AND BITAND(C.PROPERTY
, 32) != 32 /* NOT HIDDEN */
-----------------------------------------
/* TABLE HAS AN UNSUPPORTED DATATYPE */
AND ((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. PKEYS 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 DOESNT HAVE AT LEAST ONE SCALAR COLUMN */
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)
) /* END COL$ EXISTS SUBQUERY */
----------------------------------------------
THEN 0 ELSE 1 END) GENSBY
FROM SYS.OBJ$ O
, SYS.USER$ U
, SYS.TAB$ T
WHERE O.OWNER# = U.USER#
AND O.OBJ# = T.OBJ#
AND T.OBJ# = O.OBJ#
|
|
|
|