Bounced mail - Paul VanWegen
}
} ----- Transcript of session follows -----
} 550 hp.com!@!vanwegen... Host unknown
}
} ----- Unsent message follows -----
} Received: by hpbs3645.boi.hp.com
} (1.38.193.4/15.5+IOS 3.22) id AA01273; Tue, 29 Aug 1995 08:30:56 -0600
} From: Jack Parker <jparker@hpbs3645.boi.hp.com>
} Return-Path: <jparker@hpbs3645.boi.hp.com>
} Message-Id: <9508291430.AA01273@hpbs3645.boi.hp.com>
} Subject: Re: Preserve Extents
} To: hp.com!@!vanwegen ("Paul VanWegen") (Paul VanWegen)
} Date: Tue, 29 Aug 95 8:30:55 MDT
} In-Reply-To: <199508290255.AA09869@osa04.firststate.com.au>; from "Paul VanWegen" at Aug 29, 95 12:59 (noon)
} Mailer: Elm [revision: 70.85]
}
} >
} > Jack
} > Firstly thanks for the script. It has proved most useful as a
} > starting point.
}
} Interesting - I get more mileage out of this script than any of my other
} more detailed work. I essentially wrote it in an afternoon to show Peter
} Botcherby that it could be done.
}
} >
} > Some comments you might be interested in
}
} Most certainly.
}
} > 1. It appears that the dbschema is in tabid order from systables.
}
} Sounds likely.
}
} > 2. tbcheck -pe displays each dbspaces and the tables within it. This
} > can be used to retain the original dbspaces rather than pass a
} > parameter to the script
}
} I see that in a 4/27/95 version of this script I did in fact alter it to
} work of off tbcheck. I was working with Jim Will with that version trying
} to make it handle multiple dbspaces when Jim fell off the face of the planet,
} so I have this partially tested version out here.... want it?
}
} > 3. I am not sure but the resultant newschema cannot be used by
} > dbimport as it does not contain the unload file names. Please
} > correct me if i am wrong.
}
} I would expect that you are correct. My only fear in using dbexport vs
} dbschema is that dbimport will ignore the extent information. If you
} would like to try I'd be happy to work with you on it, or just stand
} back and watch you go.
}
} > 4. The script could be modified to use the schema file produced by
} > dbexport.
}
} Thanks for your thoughts.
}
} cheers
} j.
_____________________________________________________________________________
Jack Parker - Hewlett Packard, BSMC Boise, Idaho, USA
jparker@hpbs3645.boi.hp.com
_____________________________________________________________________________
Back up my hard drive? You mean these things can actually run in reverse?
_____________________________________________________________________________
Any opinions expressed herein are my own and not those of my employers.
_____________________________________________________________________________