hey,
I have the following query
select to_char(sysdate,'DD-MM-YYY HH24:MI:SS'),
a.tablespace_name ,
tbsize ,
tbfree ,
b.tbfree/a.tbsize*100 "ratio" ,
b.Largest "Largest space"
from
( select tablespace_name,sum(bytes)/1024/1024 tbsize
from dba_data_files
group by tablespace_name) a,
( select tablespace_name,sum(bytes)/1024/1024 tbfree,
max(bytes)/1024/1024 Largest
from dba_free_space
group by tablespace_name) b
where a.tablespace_name=b.tablespace_name
order by 4 ;
I need to insert the result of this query into a table.
What would be that table definition?
This above script i will put on a scheduler which run and populate the table.
Thanks