how to compress database and move indexes to different tablespace

From: <suskind_at_bbs.mdcbbs.com>
Date: 2 Sep 92 10:06:26 GMT
Message-ID: <1992Sep2.100626.1_at_bbs.mdcbbs.com>


I am trying to compress my database. While I am at it I am moving stuff into various tablespaces to improve performance and layout. My original database has only ONE tablespace "system". My new database will have
"system", "user", "temp", and "index". I can see how to easily move
a user's tables into the "user" tablespace by only giving him resource
in that tablespace and altering his user account so "user" is his default tablespace.

However, how to I move the corrisponding indexes? I have tried using the
"show" option of IMP to generate a file, but this file is in such a poor
format I cannot use it without EXTENSIVE editing. Does anybody have a utility that will take the file generated by the "show" option and make it
usable? The format I get is ONLY 80 column records and EVERY line is enclosed in double quotes.

thanks in advance

+---------------------------------------------------------------------+
Barry A. Suskind                  Internet:   suskind%edoras_at_mdcbbs.com
MaBell: 703-560-5000x2348             UUCP: uunet!mdcbbs!edoras!suskind
E-Systems / Melpar Division 7700 Arlington Blvd, Falls Church, VA 22046
JSNM                                             Just Stark Naked Magic
Received on Wed Sep 02 1992 - 12:06:26 CEST

Original text of this message