Re: IMP, suggestion for extents ..(Need!!!)???

JK,

When you export with COMPRESS option but without pre-created table in your destination database and IGNORE=Y option during import, Oracle will use total extent size of your table as INTIAL. INTIAL and EXTENT did affect the growth of your table. So please be aware of these figures.

Reid Lai

JK Yao wrote:

> dear all,
>
> I had exported our database from Oracle7.3.4 with compress=Y and
> imported to 8.1.6.
>
> Some big tables, the extents are kind of huge. For example, one of my
> table have EXTENT INITIAL 200M and NEXT 200M, is that ok? What should
> I set my next and initial. Small and big INITIAL or NEXT have any
> effect?
>
> Thanks a lot
> regards,
> JK
Received on Fri Aug 31 2001 - 02:00:48 CDT