Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> File size difference between table in database and exported file

File size difference between table in database and exported file

From: Jerome Moinet <jmoinet_at_netcourrier.com>
Date: Fri, 25 Feb 2000 10:21:10 +0100
Message-ID: <895hig$e2r$1@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 Fri Feb 25 2000 - 03:21:10 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US