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

we used :

table size : 1.8 Gb (select bytes from dba_segment where segment_name = T1) and (select blocks from dba_tables where table_name = T1)

and

exported file : 2.43 Gb (ls -l exported_file | awk {'print $5i/1048576 " Mo"'}

is there another way of calculation ?

Thanks

"Chris Hamilton" <ToneCzar_at_erols.com> a écrit dans le message news: sj1dbso25vnjpl2qmgg2a7u2u39b2jurca_at_4ax.com...
> 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.
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> Christopher Hamilton
> Oracle DBA -- Sandbox.com
> chamilton_at_sandbox-inc.com
> http://www.sandbox.com/
Received on Fri Feb 25 2000 - 16:02:35 CET