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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Export question.

RE: Export question.

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Thu, 10 May 2001 08:56:08 -0700
Message-ID: <F001.002FF764.20010510084608@fatcity.com>

>-----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

Original text of this message

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