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

Thanks,

we do not use BLOB, CLOB, or LOB .

"Pat Keenan" <pjkeenan_at_ix.netcom.com> a écrit dans le message news: 38B7FABB.4B28720_at_ix.netcom.com...
> 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 Mon Feb 28 2000 - 10:56:32 CET