Re: DB defragmentation

J.Golovaty (golovaty_at_crs.ch) wrote:
: Instralling Designer 2000 I peacefully reached the end of step 13
: 'Pre-checks before installations' where was written:' if SYSTEM
: tablespace is fragmented you'd rectify it by perfprming full DB export
: and re-import...'
: So I exported it. But what to do now? How to merge the fragments
: togeather Manual doesn't say. I couldn't find the info in other manuals
: I have either(evid. I don't have the whole complect).
: Please help
: JG

just do an IMP. follow the prompts and it will ask you if you want to compress extents. say Y.

:)

--
    ..uu.           Randy DeWoolfson          ----------------------
  .?$" '?i     .                              I  randyd_at_cais.com   I
 .T^M  ._at_"    d9    .    .f   ,.un.  t     ,  I--------------------I
 "  Z :#"    M `8   U    <  .dP"``Y# `M   _at_"  I brandall_at_erols.com I
    &H?`    Xl _R   $5.  $  ?*    _at_   'P,#"   I--------------------I
  ,d#^*L   :RP'~$b  f`$L:M  Xf  .f'    dH`    I     ,\//.      X   I
    &  'M ,P    `E  M   "$  Mux~      n!`     I     |o o|          I
   dk   `h"       ' j     " y"       *~       I=oOO==(_)==Ooo======I