table size doubled after convert from SAS
hi all, i converted some data sets from SAS to Oracle. the size of some smaller data sets were reduced significantly (from 300+MB to 3MB). but big data sets were increased much more (from 800+MB to 1.6GB). 1.6GB is the segment bytes, it's almost the same size as SAS data if calculated w/(row# * row length). but the segment size is more meaningful to me since i'm not insert any more data into it after the conversion. all the datatype in the big table are numbers. The default block size of the table space is 8K. Anybody knows why the size are vary and how to solve the problem?
and do u guys know how to do detailed statistic analysis on oracle data? e.g. how to get the mean value with some specific conditions like 'weight' with an attribute? I can do it in SAS but not sure about oracle. thanks alot!