VIEW: SYS.KU$_TABLESPACE_VIEW

Source

View Text - Preformatted

select '1', '0',
          t.ts#, t.name,  t.owner#, t.online$, t.contents$, t.undofile#,
          t.undoblock#, t.blocksize, t.inc#, t.scnwrp, t.scnbas, t.dflminext,
          t.dflmaxext, t.dflinit, t.dflincr, t.dflminlen, t.dflextpct,
          t.dflogging, t.affstrength, t.bitmapped, t.plugged, t.directallowed,
          -- Convert 'flags' to a value that the pre-11.2 xsl stylesheet
          -- can process: if archive compressed and version < 11.2,
          -- turn off compression.  The block format for archive compression
          -- is not supported pre-11.2, so the compression bits must be
          -- set to NOCOMPRESS.
          --  #define KTT_COMPRESSED              0x40      (64)
          -- #define KTT_ARCH1_COMPRESSION  ((ub4)0x20000)  (131072)
          -- #define KTT_ARCH2_COMPRESSION  ((ub4)0x40000)  (262144)
          -- #define KTT_ARCH3_COMPRESSION  ((ub4)0x80000)  (524288)
          -- #define KTT_HCC_ROW_LOCKING    ((ub4)0x400000) (4194304)
          case when bitand (t.flags,131072+262144+524288+4194304) = 0
                   then t.flags
               when dbms_metadata.get_version >= '11.02.00.00.00' then t.flags
               else t.flags - bitand(t.flags,64+131072+262144+524288+4194304)
          end,
          t.pitrscnwrp, t.pitrscnbas, t.ownerinstance, t.backupowner,
          case bitand(t.flags,1024)
            when 1024 then
              (select t2.name
               from ts$ t2
               where t.dflmaxext  = t2.ts#)
            else NULL end,
          t.spare1, t.spare2, t.spare3, to_char(t.spare4,'YYYY/MM/DD HH24:MI:SS'),
          cast(multiset(select value(f) from ku$_file_view f
                       where f.ts_num = t.ts#
                      ) as ku$_file_list_t
             ),
          (select encryptionalg
           from v$encrypted_tablespaces et
           where  et.ts# = t.ts#)
 from ts$ t
 where  t.online$  IN (1, 2, 4)
 and    bitand(t.flags,2048) = 0
 and    (SYS_CONTEXT('USERENV','CURRENT_USERID') = 0
        OR EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '0'
, T.TS#
, T.NAME
, T.OWNER#
, T.ONLINE$
, T.CONTENTS$
, T.UNDOFILE#
, T.UNDOBLOCK#
, T.BLOCKSIZE
, T.INC#
, T.SCNWRP
, T.SCNBAS
, T.DFLMINEXT
, T.DFLMAXEXT
, T.DFLINIT
, T.DFLINCR
, T.DFLMINLEN
, T.DFLEXTPCT
, T.DFLOGGING
, T.AFFSTRENGTH
, T.BITMAPPED
, T.PLUGGED
, T.DIRECTALLOWED
, -- CONVERT 'FLAGS' TO A VALUE THAT THE PRE-11.2 XSL STYLESHEET -- CAN PROCESS: IF ARCHIVE COMPRESSED
AND VERSION < 11.2
, -- TURN OFF COMPRESSION. THE BLOCK FORMAT FOR ARCHIVE COMPRESSION -- IS NOT SUPPORTED PRE-11.2
, SO THE COMPRESSION BITS MUST BE -- SET TO NOCOMPRESS. -- #DEFINE KTT_COMPRESSED 0X40 (64) -- #DEFINE KTT_ARCH1_COMPRESSION ((UB4)0X20000) (131072) -- #DEFINE KTT_ARCH2_COMPRESSION ((UB4)0X40000) (262144) -- #DEFINE KTT_ARCH3_COMPRESSION ((UB4)0X80000) (524288) -- #DEFINE KTT_HCC_ROW_LOCKING ((UB4)0X400000) (4194304) CASE WHEN BITAND (T.FLAGS
, 131072+262144+524288+4194304) = 0 THEN T.FLAGS WHEN DBMS_METADATA.GET_VERSION >= '11.02.00.00.00' THEN T.FLAGS ELSE T.FLAGS - BITAND(T.FLAGS
, 64+131072+262144+524288+4194304) END
, T.PITRSCNWRP
, T.PITRSCNBAS
, T.OWNERINSTANCE
, T.BACKUPOWNER
, CASE BITAND(T.FLAGS
, 1024) WHEN 1024 THEN (SELECT T2.NAME
FROM TS$ T2
WHERE T.DFLMAXEXT = T2.TS#) ELSE NULL END
, T.SPARE1
, T.SPARE2
, T.SPARE3
, TO_CHAR(T.SPARE4
, 'YYYY/MM/DD HH24:MI:SS')
, CAST(MULTISET(SELECT VALUE(F)
FROM KU$_FILE_VIEW F
WHERE F.TS_NUM = T.TS# ) AS KU$_FILE_LIST_T )
, (SELECT ENCRYPTIONALG
FROM V$ENCRYPTED_TABLESPACES ET
WHERE ET.TS# = T.TS#)
FROM TS$ T
WHERE T.ONLINE$ IN (1
, 2
, 4)
AND BITAND(T.FLAGS
, 2048) = 0
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') = 0 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))