how to compress database and move indexes to different tablespace
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 MagicReceived on Wed Sep 02 1992 - 12:06:26 CEST