Re: File size difference between table in database and exported file

On export Varchar2 fields are not compressed. Also i think empty fields will still take up thier full space but have not verified it.

Jerome Moinet wrote in message
<895hig$e2r$1_at_ssauraab-i-1.production.compuserve.com>...
>Could there be a reason for the big diference between a table size in
>database and the size of the exported file ?
>
>table size : 1.8 Gb (select bytes from dba_segment where segment_name = T1)
>and (select blocks from dba_tables where table_name = T1)
>exp user_at_database file=F1 table=T1 direct=y raws=y
>exported file : 2.43 Gb (ls -l F1 | awk {'print $5i/1048576 " Mo"'}
>
>Oracle version 8.0.6
>OS AIX 4.3.1
>
>Oracle support don't have any answer to this.
>
>
Received on Fri Feb 25 2000 - 00:00:00 CET