Export question.

<SPAN

class=968072114-10052001>All,
<SPAN

class=968072114-10052001> 
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 !!!!!
<SPAN

class=968072114-10052001> 
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.

<SPAN

class=968072114-10052001> 
Does export merely
backup the data or does it also backup other stuff (unused blocks, preallocated etc.)
<SPAN

class=968072114-10052001> 
<SPAN

class=968072114-10052001>Regards
<FONT

face=Arial size=2>
Lee Robertson
 

The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. Received on Thu May 10 2001 - 10:38:01 CDT