SQL> desc KU$_FILE_VIEW
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 NAME                                               VARCHAR2(513)
 FNAME                                              VARCHAR2(1026)
 FSIZE                                              NUMBER
 RESIZE                                             NUMBER
 MAXEXTEND                                          NUMBER
 INC                                                NUMBER
 TS_NUM                                             NUMBER
 IS_OMF                                             NUMBER

desc DBA_HIST_TBSPC_SPACE_USAGE
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SNAP_ID                                            NUMBER
 DBID                                      NOT NULL NUMBER
 TABLESPACE_ID                                      NUMBER
 TABLESPACE_SIZE                                    NUMBER
 TABLESPACE_MAXSIZE                                 NUMBER
 TABLESPACE_USEDSIZE                                NUMBER
 RTIME                                              VARCHAR2(25)

 select distinct TABLESPACE_ID,v.name, (a.TABLESPACE_MAXSIZE-b.TABLESPACE_MAXSIZE ) tbs_growth 
from 
(select TABLESPACE_MAXSIZE 
from  DBA_HIST_TBSPC_SPACE_USAGE where rtime = (select min(rtime) 
from DBA_HIST_TBSPC_SPACE_USAGE 
where trunc(to_date(rtime,'mm/dd/yyyy hh24:mi:ss')) = trunc(sysdate - 3))) a ,
(select TABLESPACE_MAXSIZE from  DBA_HIST_TBSPC_SPACE_USAGE 
where rtime = (select max(rtime) 
from DBA_HIST_TBSPC_SPACE_USAGE) ) b , v$tablespace v ,DBA_HIST_TBSPC_SPACE_USAGE d
where v.ts#=d.TABLESPACE_ID and v.name like upper('&tbs')  ;