Re: Tablespace Reorg
From: J.Reulen <jhr_at_sci.kun.nl>
Date: 1996/02/01
Message-ID: <4er7rl$oh8_at_wn1.sci.kun.nl>#1/1
Date: 1996/02/01
Message-ID: <4er7rl$oh8_at_wn1.sci.kun.nl>#1/1
chopskie_at_ix.netcom.com (Edward Chopskie) wrote:
>In article <4ebb54$59r_at_norm.uoknor.edu>,
> "Mark C. Rush" <mrush_at_ocdis01.tinker.af.mil> wrote:
>>How do you reorg a tablespace?
>>
>>Export all the objects in the tablespace, drop them, then import?
>>
>>If so, how do you find all of the objects in a tablespace?
To reorg a table space
Make a full database export.
Then drop the tablespace you want to reorg.
Create a new tablespace.
Import the full database with the option ignore create failure 'off'.
You get a lot of error message because all object in the database exists except the one's that used to be in the tablespace you dropped.
Hopes this helps
Guido Reulen. Received on Thu Feb 01 1996 - 00:00:00 CET