select substr(v$tablespace.name,1,16) as tablespace, blocks, substr(v$datafile.name,1,45) as datafile from v$tablespace, v$datafile where v$tablespace.ts#=v$datafile.ts# /