Re: Tablespace reorg with Import/Export
Date: 1995/10/26
Message-ID: <46ojdd$sh8_at_athos.cc.bellcore.com>#1/1
In article <46gpq4$a8t_at_ixnews7.ix.netcom.com>, hank_at_legacytech.com says...
*>
*>
*>
*> 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===
*>
If the imp/exp is done on a table level it will leave the first, next extents
alone unless compress=y is specified. If it is the import will attemp to
create an extent equal to the size of all the allocated extents. If it can't
find the contiguous space it bombs. If the imp is done on the tablespace
level it will defag the entire tablespace. The imp/exp object(s) can be
dropped or truncated depending what you want to do. (e.g. you want to defrag
but not move the high water marks)
Received on Thu Oct 26 1995 - 00:00:00 CET