To check the Partition Info

 SELECT A.TABLE_NAME,A.PARTITIONING_TYPE,B.PARTITION_NAME,B.TABLESPACE_NAME,D.FILE_NAME,D.BYTES/1024/1024/1024 "BYTES" FROM
 DBA_TAB_PARTITIONS B,DBA_PART_TABLES A,DBA_TABLESPACES C,DBA_DATA_FILES D WHERE A.TABLE_NAME=B.TABLE_NAME  AND
 D.TABLESPACE_NAME=C.TABLESPACE_NAME AND C.TABLESPACE_NAME=B.TABLESPACE_NAME  AND A.TABLE_NAME IN(B_FORECAST_MSPN_DEMAND_TREND)