SQL> desc v$tablespace
Name Null? Type
----------------------------------------- -------- ----------------------------
TS# NUMBER
NAME VARCHAR2(30)
INCLUDED_IN_DATABASE_BACKUP VARCHAR2(3)
BIGFILE VARCHAR2(3)
FLASHBACK_ON VARCHAR2(3)
ENCRYPT_IN_BACKUP VARCHAR2(3)
SQL> select *
2 from v$tablespace;
TS# NAME INCLUDED_ BIGFILE FLASHBACK ENCRYPT_I
---------- --------------- --------- --------- --------- ---------
0 SYSTEM YES NO YES
1 SYSAUX YES NO YES
2 UNDOTBS1 YES NO YES
4 USERS YES NO YES
3 TEMP NO NO YES
6 EXAMPLE YES NO YES
7 TBS_TEST YES NO YES
8 TBS_UNDOTEST YES NO YES
9 TBS_TEMPTEST NO NO YES
9 rows selected.
SQL>
Name Null? Type
----------------------------------------- -------- ----------------------------
TS# NUMBER
NAME VARCHAR2(30)
INCLUDED_IN_DATABASE_BACKUP VARCHAR2(3)
BIGFILE VARCHAR2(3)
FLASHBACK_ON VARCHAR2(3)
ENCRYPT_IN_BACKUP VARCHAR2(3)
SQL> select *
2 from v$tablespace;
TS# NAME INCLUDED_ BIGFILE FLASHBACK ENCRYPT_I
---------- --------------- --------- --------- --------- ---------
0 SYSTEM YES NO YES
1 SYSAUX YES NO YES
2 UNDOTBS1 YES NO YES
4 USERS YES NO YES
3 TEMP NO NO YES
6 EXAMPLE YES NO YES
7 TBS_TEST YES NO YES
8 TBS_UNDOTEST YES NO YES
9 TBS_TEMPTEST NO NO YES
9 rows selected.
SQL>