SELECT * FROM v$tablespace;

TS#        NAME                          
---------- ------------------------------
         0 SYSTEM                        
         3 TEMPORARY_DATA                
         2 ROLLBACK_DATA                 
         1 USER_DATA                     
         4 INDX