Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Export question.
>-----Original Message-----
>From: Robertson Lee - lerobe [mailto:lerobe_at_acxiom.co.uk]
>
>I have recently ran an analysis on a table and when calculating the table size using
>num_rows*avg_row_len this came out at about 420Mb. Nothing strange about that, however the
>amount of space this table is taking up is about 4.6Gb !!!!!
>
>Instant case for a reorg I thought, however, I am currently exporting this table and
> suddenlyn oticed that the dump file is now in excess of 1.5Gb and still going strong.
>
>Does export merely backup the data or does it also backup other stuff (unused blocks,
>preallocated etc.)
Export only backs up the data (and the DDL needed to recreate objects). Was the analyze done using compute or estimate? The estimage of avg_row_len could have been off. Received on Thu May 10 2001 - 10:56:08 CDT