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

On Fri, 25 Feb 2000 10:56:17 +0100, Deana Strbevski <deana.strbevski_at_ina.hr> wrote:

>You can find reason in indexes,grants,trigger etc.
>When you export table you export index and other object

No, that is incorrect. You export only the definitions of the above objects. The definitions certainly wouldn't take up 643 mb of space in the export file.

There must be an error in either your calculations or the way you've reported it here.

Chris

>Jerome Moinet wrote:
>>
>> 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.