DBA Data[Home] [Help]

VIEW: SYS.GV_$TABLESPACE

Source

View Text - Preformatted

select "INST_ID","TS#","NAME","INCLUDED_IN_DATABASE_BACKUP","BIGFILE","FLASHBACK_ON","ENCRYPT_IN_BACKUP","CON_ID" from gv$tablespace
View Text - HTML Formatted

SELECT "INST_ID"
, "TS#"
, "NAME"
, "INCLUDED_IN_DATABASE_BACKUP"
, "BIGFILE"
, "FLASHBACK_ON"
, "ENCRYPT_IN_BACKUP"
, "CON_ID"
FROM GV$TABLESPACE