Re: Oracle 7.2: Need advice on Export/Import compression

Paul,

Normally, when you run export with compress=N, you will have in the export file the same storage option ( initial,next,minextents,maxextent,pctincrease) as you have currently in your table. If it's not the case this is a BUG.

With compress=Y, then export will generate new storage parameters that will fit the table into 1 extent.

What you can do to workaround your problem, is to export the table, drop the table, and under sqlplus recreate the table with the correct parameters, than do an import with ignore=Y. import will see that the table already exists, and will ignore the erors and the re-import the data.

I can suggest for reorganisation problem to use Platinum TSreorg for oracle. This is a great product...

Patrick.
In article <6o1sii$vch$1_at_nnrp1.dejanews.com>,   paul.vincent_at_uce.ac.uk wrote:
> I have a table with an initial extent of 50Mb and 120 additional extents of
> 10Mb each. I know that a huge amount of the data has been deleted, so I need
> to compress it down (I estimate there's now about 65Mb of data there).
>
> According to the Oracle Server Utilities manual, exporting with COMPRESS=N
> would cause the subsequent re-import to recreate the table with an initial
> extent equal in size to the sum of all the current extents (i.e. 50Mb +
> 120*10Mb = 1250Mb). But it says if I run with COMPRESS=Y, then the initial
> extent of the recreated table should be only as big as necessary (i.e. I'd
> guess about 65Mb).
>
> However, when I run with COMPRESS=Y, then drop the table and re-import it,
> the table ends up with a 1250Mb initial extent, just as though I'd specified
> COMPRESS=N. Is this a known bug? Am I doing something wrong, or
> misinterpreting the manual? Any advice welcome!
>
> Paul
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 09 1998 - 07:51:47 CDT