VIEW: SYS.DBA_ILMPOLICIES

Source

View Text - Preformatted

select  a.name,
        decode(ptype, 1, 'DATA MOVEMENT'),
        null,
        decode(bitand(FLAG,1),1,'NO',0,'YES'),
        decode(bitand(FLAG,64),0,'NO',64,'YES')
  from sys.ilm$ a, sys.user$ b
 where a.owner# = b.user#
   and bitand(a.flag, 8)   = 0
union
select  a.name,
        decode(ptype, 1, 'DATA MOVEMENT'),
        c.name,
        decode(bitand(FLAG,1),1,'NO',0,'YES'),
        decode(bitand(FLAG,64),0,'NO',64,'YES')
  from sys.ilm$ a, sys.user$ b, sys.ts$ c
 where a.owner# = b.user#
   and a.ts#    = c.ts#
   and bitand(a.flag, 8) = 8

View Text - HTML Formatted

SELECT A.NAME
, DECODE(PTYPE
, 1
, 'DATA MOVEMENT')
, NULL
, DECODE(BITAND(FLAG
, 1)
, 1
, 'NO'
, 0
, 'YES')
, DECODE(BITAND(FLAG
, 64)
, 0
, 'NO'
, 64
, 'YES')
FROM SYS.ILM$ A
, SYS.USER$ B
WHERE A.OWNER# = B.USER#
AND BITAND(A.FLAG
, 8) = 0 UNION SELECT A.NAME
, DECODE(PTYPE
, 1
, 'DATA MOVEMENT')
, C.NAME
, DECODE(BITAND(FLAG
, 1)
, 1
, 'NO'
, 0
, 'YES')
, DECODE(BITAND(FLAG
, 64)
, 0
, 'NO'
, 64
, 'YES')
FROM SYS.ILM$ A
, SYS.USER$ B
, SYS.TS$ C
WHERE A.OWNER# = B.USER#
AND A.TS# = C.TS#
AND BITAND(A.FLAG
, 8) = 8