Re: Tablespace reorg with Import/Export

In message <46gpq4$a8t_at_ixnews7.ix.netcom.com>, hank_at_legacytech.com (Hank Eskin) writes:

>
>
> Simple question:
>
> When an Import/Export operation is done on a database,
> does the import:
>
> (1) re-set all the existing table extents to what is specified
> in the Table definition (FIRST, NEXT EXTENT), or
> (2) to what is specified in the Tablespace default definition, or
> (3) does it leave the existing Extents for the existing
> tables alone, and just defrags the unused space??
>
> Plesae post and/or email to hank_at_legacytech.com!
>
> Thanks in advance.
>
> - hank
>
>===sgs r wst f bndwdth===
>

Hank,

Your tables will be imported using the tablespace's storage parameters unless you create the table(s) first and specify the storage parameters. Use IGNORE=Y on your import command line to permit import to use the new storage parameters.

Cheers -- Angelo Melendez Received on Tue Oct 24 1995 - 00:00:00 CET