In the absence of any UI based Oracle Database access tools, one has to access the same using SQL PLUS.
The following tables are helpful in getting information about tablespaces
Referred from http://www.cs.uvm.edu/oracle9doc/server.901/a90117/tspaces.htm#570
I have used the following tables:
V$TABLESPACE : Name and number of all tablespaces from the control file.
V$DATAFILE : Information about all datafiles, including tablespace number of owning tablespace.
DBA_DATA_FILES : Shows files (datafiles) belonging to tablespaces.
