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

With DIRECT=y your export is a little larger than with DIRECT=n. That's because your exacting blocks directly, instead of rows. But I wouldn't think that would result in over 600 MB overhead. You're definitely trading space for speed.

"Jerome Moinet" <jmoinet_at_netcourrier.com> wrote in message news: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 Sun Mar 12 2000 - 02:36:47 CET