select TS#, -- TS# NUMBER NAME, -- NAME VARCHAR2(30) INCLUDED_IN_DATABASE_BACKUP, -- INCLUDED_IN_DATABASE_BACKUP VARCHAR2(3) BIGFILE, -- BIGFILE VARCHAR2(3) FLASHBACK_ON, -- FLASHBACK_ON VARCHAR2(3) ENCRYPT_IN_BACKUP -- ENCRYPT_IN_BACKUP VARCHAR2(3) from GV$TABLESPACE where inst_id = USERENV('Instance')