Re: Export didn't compress my tables?

In article <2qtohv$p1a_at_news.delphi.com>

           slott_at_news.delphi.com "SLOTT_at_DELPHI.COM" writes:

> Using Oracle 6.0.37. We exported tables owned by a user using
> the compress extents option.
> We used import to list the contents of our export file.
> The initial size for one of our tables was 40960,the next size
> was 102400. Why was the next so big? Did it inherit the
> next from the current definitions?

I think ORACLE sets nextextent and pctincrease by default on export. To import table into compressed sizes, just pre-create the table with the initial, next and pctincrease params set in advance, then import. That should do it.

> Thanks in advance.
> S.Lott
>
 

-- 
Alligator Descartes
v_at_istellar.demon.co.uk