select * from v$tablespace;

0SYSTEM YESNO YES 1SYSAUX YESNO YES 2UNDOTBS1 YESNO YES 4USERS YESNO YES 3TEMP NONOYES 6EXAMPLE YESNO YES 7AYDYESNOYES 8AYD_TEMP NONOYES 9CD_TEMP NONOYES 10CD_DATA YESNO YES 11OK_TEMP NONOYES 12OK_ZHZS YESNO YES 15AHZHZS_TEMPNONO YES 16AHZHZS_DATAYESNO YES