File size difference between table in database and exported file
From: Jerome Moinet <jmoinet_at_netcourrier.com>
Date: 2000/02/25
Message-ID: <895hig$e2r$1_at_ssauraab-i-1.production.compuserve.com>#1/1
Date: 2000/02/25
Message-ID: <895hig$e2r$1_at_ssauraab-i-1.production.compuserve.com>#1/1
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