SELECT ts$.ts#, 'SYSTEM', ts$.name,
DECODE(ts$.online$, 1, 'ONLINE', 4, 'ONLINE', 'OFFLINE'),
DECODE(ts$.contents$, 0, 'PERMANENT', 1, 'TEMPORARY'),
ts$.dflinit, ts$.dflincr, ts$.dflextpct, ts$.dflminext,
ts$.dflmaxext, NVL(ts$.dflminlen, 0), ts$.dflogging,
ts$.bitmapped, ts$.flags, ts$.blocksize,
decode(bitand(ts$.flags, 4096), 4096, ts$.affstrength, 0)
FROM sys.ts$ ts$
WHERE ts$.online$ IN (1, 2, 4) AND
ts$.ts# != 0 AND
bitand(ts$.flags,2048) !=2048
SELECT TS$.TS#
, 'SYSTEM'
, TS$.NAME
,
DECODE(TS$.ONLINE$
, 1
, 'ONLINE'
, 4
, 'ONLINE'
, 'OFFLINE')
,
DECODE(TS$.CONTENTS$
, 0
, 'PERMANENT'
, 1
, 'TEMPORARY')
,
TS$.DFLINIT
, TS$.DFLINCR
, TS$.DFLEXTPCT
, TS$.DFLMINEXT
,
TS$.DFLMAXEXT
, NVL(TS$.DFLMINLEN
, 0)
, TS$.DFLOGGING
,
TS$.BITMAPPED
, TS$.FLAGS
, TS$.BLOCKSIZE
,
DECODE(BITAND(TS$.FLAGS
, 4096)
, 4096
, TS$.AFFSTRENGTH
, 0)
FROM SYS.TS$ TS$
WHERE TS$.ONLINE$ IN (1
, 2
, 4) AND
TS$.TS# != 0 AND
BITAND(TS$.FLAGS
, 2048) !=2048
|
|
|