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
FROM sys.ts$ ts$
WHERE ts$.online$ in (1, 2, 4) and ts$.ts# != 0 and ts$.bitmapped = 0
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
FROM SYS.TS$ TS$
WHERE TS$.ONLINE$ IN (1
, 2
, 4)
AND TS$.TS# != 0
AND TS$.BITMAPPED = 0
|
|
|