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

From: Jerome Moinet <jmoinet_at_netcourrier.com>
Date: Fri, 25 Feb 2000 14:03:32 +0100
Message-ID: <895ujp$ic4$1@ssauraab-i-1.production.compuserve.com>

ooops, sorry, i used :

exp user_at_database file=F1 table=T1 direct=y raws=y indexes=n grants=n constraints=n

and there is no trigger on this table

thanks

"Deana Strbevski" <deana.strbevski_at_ina.hr> a écrit dans le message news: 38B651C1.8450BA31_at_ina.hr...
> You can find reason in indexes,grants,trigger etc.
> When you export table you export index and other object
>
> 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 Fri Feb 25 2000 - 07:03:32 CST