GV$TABLESPACE
select inst_id, -- INST_ID NUMBER tstsn, -- TS# NUMBER tsnam, -- NAME VARCHAR2(30) decode -- INCLUDED_IN_DATABASE_BACKUP VARCHAR2(3) (bitand (tsflg, 2), 2, 'NO', 'YES') from x$kccts where tstsn != -1

home |  up  |  mailbox