Hi All,
I have a serious space issue with my 8i server running on Sun E3500, Ultra sparc. The problem is related to export utility. I exported a user from ptroduction to my staging area with compress = n, and ater with compress = y. The amount of space occupied by the tablespace dedicated for this schema shoot up 3 imes than the actual one in prod. I later had to export the same schema on staging to test/development region. I again tried to export with compress = y and n. The space shoot up to 12times actual one. Is there a way I can get rid of such space increase. Actual size in prod was 205Mb and in staging it is around 700Mb and now in testing area it is 3.2Gb. Can anyone of you let me know the reason as well as remedy for this. Anywork around available?