Re: Import with new table & index extent sizes

Hi Greg,

I think that putting a minmum extent size of 4M on the tablespace will do exactly what you want.

_at_   Regards,
_at_   Steve Adams
_at_   http://www.ixora.com.au/
_at_   http://www.christianity.net.au/
_at_   
_at_   Going to OpenWorld?
_at_   Catch the Ixora performance tuning seminar too!
_at_   See http://www.ixora.com.au/seminars/ for details.

On Thu, 31 Aug 2000 16:16:29 -0400, Gregory P Lechkun <lechkung_at_dteenergy.com> wrote:

>
>--------------616E89D0651821B3847CDEDD
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>Hello,
>
>I have a full export and I want to import it into a new instance so that
>the table and index extent sizes default to what my new instance's
>tablespace extents default sizes are. I'm doing this so that all my
>objects in the tablespaces are set to a uniform size (4MB).
>
>Question: How do I make the import command ignore the table and index
>sizes that are set in my old instance and use the tablespace default
>setting?
>
>This is what par file looks like:
>
> BUFFER=5242880
> COMPRESS=N
> CONSISTENT=Y
> CONSTRAINTS=Y
> FILE=CIL_EXPORTS:UP02_FULL_EXPORT
> FULL=Y
> GRANTS=Y
> INDEXES=Y
> LOG=CIL_EXPORTS:UP02_EXPORT.LOG
> ROWS=Y
>
>--
>Thanks in advance,
>Greg Lechkun
>gpl :-)
  Received on Tue Sep 05 2000 - 11:05:59 CEST