Re: Tablespace reorg with Import/Export

Jeff Van Voorhis (JeffVanV_at_aol.com) wrote:
: > (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??
 =
: >
: If you use EXP setting compress=Y export will "compress" all table and index extents to 1. It sets
: the initial extent to what EXP thinks is the correct size - but leaves the NEXT EXTENT the same as
: the table default.

That is true if you delete your tables before importing them. If not, you will get as many extents as you had before. Or maybe more, because of chaining and use of the freespace in blocks.

: You may want to create your own CREATE TABLE and CREATE INDEX scripts.

Yes, if you want to create bigger tables and indexes (bigger extents). But the export file containes those scripts. So if the tables dosen't exist, they will be created during the import.

: Make sure you do a COLD backup before starting this. (In know you would have anyway - but we
: have all been burned at least once doing this!).
 

: Jeff

I couldn't agree more.

Morten

-- 
    .       !/                                           #######################
    %&     [>    ..               li      ..             #                     #
   #_at_\\  /+}   g8''9c   #\.=-.  .ro£=-  o6''8m   %\.--.  # Morten              #
   _at_o `?' J=  s2   @e   RP'´    "T2T"  m3   %e   H!''#|  # Kristiansen         #