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

One other thing to consider is are you using BLOB, CLOB, or LOB objects in your table?

These objects get stored in the database in their own "tables". Maybe export picks up these extra tables???

Pat Keenan

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.

Received on Sat Feb 26 2000 - 10:09:32 CST