CREATE OR REPLACE VIEW ALL_TABLES
(owner, table_name, tablespace_name, cluster_name, iot_name, status, pct_free, pct_used,
 ini_trans, max_trans, initial_extent, next_extent, min_extents, max_extents, pct_increase,
 freelists, freelist_groups, logging, backed_up, num_rows, blocks, empty_blocks, avg_space,
 chain_cnt, avg_row_len, avg_space_freelist_blocks, num_freelist_blocks, degree, instances,
 cache, table_lock, sample_size, last_analyzed, partitioned, iot_type, temporary, secondary,
 nested, buffer_pool, row_movement, global_stats, user_stats, duration, skip_corrupt, monitoring,
 cluster_owner, dependencies, compression, dropped)
AS
SELECT u.name,
	   o.name,
	   decode(bitand(t.property,  2151678048 ),  0 , ts.name, NULL),
	   decode(bitand(t.property,  1024 ),  0 , NULL, co.name),
	   decode((bitand(t.property,  512 ) + bitand(t.flags,  536870912 )),
			   0 ,
			  NULL,
			  co.name),
	   decode(bitand(t.trigflag,  1073741824 ),
			   1073741824 ,
			  'UNUSABLE',
			  'VALID'),
	   decode(bitand(t.property,  32  +  64 ),
			   0 ,
			  MOD(t.pctfree$,  100 ),
			   64 ,
			   0 ,
			  NULL),
	   decode(bitand(ts.flags,  32 ),
			   32 ,
			  to_number(NULL),
			  decode(bitand(t.property,  32  +  64 ),  0 , t.pctused$,  64 ,  0 , NULL)),
	   decode(bitand(t.property,  32 ),  0 , t.initrans, NULL),
	   decode(bitand(t.property,  32 ),  0 , t.maxtrans, NULL),
	   s.iniexts * ts.blocksize,
	   decode(bitand(ts.flags,  3 ),
			   1 ,
			  to_number(NULL),
			  s.extsize * ts.blocksize),
	   s.minexts,
	   s.maxexts,
	   decode(bitand(ts.flags,  3 ),  1 , to_number(NULL), s.extpct),
	   decode(bitand(ts.flags,  32 ),
			   32 ,
			  to_number(NULL),
			  decode(bitand(o.flags,  2 ),
					  2 ,
					  1 ,
					 decode(s.lists,  0 ,  1 , s.lists))),
	   decode(bitand(ts.flags,  32 ),
			   32 ,
			  to_number(NULL),
			  decode(bitand(o.flags,  2 ),
					  2 ,
					  1 ,
					 decode(s.groups,  0 ,  1 , s.groups))),
	   decode(bitand(t.property,  32  +  64 ),
			   0 ,
			  decode(bitand(t.flags,  32 ),  0 , 'YES', 'NO'),
			  NULL),
	   decode(bitand(t.flags,  1 ),  0 , 'Y',  1 , 'N', '?'),
	   t.rowcnt,
	   decode(bitand(t.property,  64 ),  0 , t.blkcnt, NULL),
	   decode(bitand(t.property,  64 ),  0 , t.empcnt, NULL),
	   decode(bitand(t.property,  64 ),  0 , t.avgspc, NULL),
	   t.chncnt,
	   t.avgrln,
	   t.avgspc_flb,
	   decode(bitand(t.property,  64 ),  0 , t.flbcnt, NULL),
	   lpad(decode(t.degree,  32767 , 'DEFAULT', nvl(t.degree,  1 )),  10 ),
	   lpad(decode(t.instances,  32767 , 'DEFAULT', nvl(t.instances,  1 )),  10 ),
	   lpad(decode(bitand(t.flags,  8 ),  8 , 'Y', 'N'),  5 ),
	   decode(bitand(t.flags,  6 ),  0 , 'ENABLED', 'DISABLED'),
	   t.samplesize,
	   t.analyzetime,
	   decode(bitand(t.property,  32 ),  32 , 'YES', 'NO'),
	   decode(bitand(t.property,  64 ),
			   64 ,
			  'IOT',
			  decode(bitand(t.property,  512 ),
					  512 ,
					 'IOT_OVERFLOW',
					 decode(bitand(t.flags,  536870912 ),
							 536870912 ,
							'IOT_MAPPING',
							NULL))),
	   decode(bitand(o.flags,  2 ),  0 , 'N',  2 , 'Y', 'N'),
	   decode(bitand(o.flags,  16 ),  0 , 'N',  16 , 'Y', 'N'),
	   decode(bitand(t.property,  8192 ),
			   8192 ,
			  'YES',
			  decode(bitand(t.property,  1 ),  0 , 'NO', 'YES')),
	   decode(bitand(o.flags,  2 ),
			   2 ,
			  'DEFAULT',
			  decode(s.cachehint,
					  0 ,
					 'DEFAULT',
					  1 ,
					 'KEEP',
					  2 ,
					 'RECYCLE',
					 NULL)),
	   decode(bitand(t.flags,  131072 ),  131072 , 'ENABLED', 'DISABLED'),
	   decode(bitand(t.flags,  512 ),  0 , 'NO', 'YES'),
	   decode(bitand(t.flags,  256 ),  0 , 'NO', 'YES'),
	   decode(bitand(o.flags,  2 ),
			   0 ,
			  NULL,
			  decode(bitand(t.property,  8388608 ),
					  8388608 ,
					 'SYS$SESSION',
					 'SYS$TRANSACTION')),
	   decode(bitand(t.flags,  1024 ),  1024 , 'ENABLED', 'DISABLED'),
	   decode(bitand(o.flags,  2 ),
			   2 ,
			  'NO',
			  decode(bitand(t.property,  2147483648 ),
					  2147483648 ,
					 'NO',
					 decode(ksppcv.ksppstvl, 'TRUE', 'YES', 'NO'))),
	   decode(bitand(t.property,  1024 ),  0 , NULL, cu.name),
	   decode(bitand(t.flags,  8388608 ),  8388608 , 'ENABLED', 'DISABLED'),
	   decode(bitand(t.property,  32 ),
			   32 ,
			  NULL,
			  decode(bitand(s.spare1,  2048 ),  2048 , 'ENABLED', 'DISABLED')),
	   decode(bitand(o.flags,  128 ),  128 , 'YES', 'NO')
  FROM sys.user$ u,
	   sys.ts$   ts,
	   sys.seg$  s,
	   sys.obj$  co,
	   sys.tab$  t,
	   sys.obj$  o,
	   sys.obj$  cx,
	   sys.user$ cu,
	   x$ksppcv  ksppcv,
	   x$ksppi   ksppi
 WHERE o.owner# = u.user# AND
	   o.obj# = t.obj# AND
	   bitand(t.property,  1 ) =  0  AND
	   bitand(o.flags,  128 ) =  0  AND
	   t.bobj# = co.obj#(+) AND
	   t.ts# = ts.ts# AND
	   t.file# = s.file#(+) AND
	   t.block# = s.block#(+) AND
	   t.ts# = s.ts#(+) AND
	   (o.owner# = userenv('SCHEMAID') OR
	   o.obj# IN
	   (SELECT oa.obj#
		   FROM sys.objauth$ oa
		  WHERE grantee# IN (SELECT kzsrorol FROM x$kzsro)) OR /* user has system privileges */
	   EXISTS
		(SELECT NULL
		   FROM v$enabledprivs
		  WHERE priv_number IN (- 45  /* LOCK ANY TABLE */,
								- 47  /* SELECT ANY TABLE */,
								- 48  /* INSERT ANY TABLE */,
								- 49  /* UPDATE ANY TABLE */,
								- 50  /* DELETE ANY TABLE */))) AND
	   t.dataobj# = cx.obj#(+) AND
	   cx.owner# = cu.user#(+) AND
	   ksppi.indx = ksppcv.indx AND
	   ksppi.ksppinm = '_dml_monitoring_enabled';