jason_goucf wrote:Are you trying to pull the information from base database or grid control db (repository) ?
yes if i had grid i could pull it, however if grid can pull it then we shuld be able to script it.
yes if i had grid i could pull itSeems like you don't have GRID... Hope you understand there is repository associated with GRID... which could store information.
Where snap_id is the AWR Snapshot id and tablespace_id is the Tablespace id.
select snap_id, tablespace_id, tablespace_size from DBA_HIST_TBSPC_SPACE_USAGE;