Re: How to rebuild a tablespace

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 13 Mar 2003 22:55:44 +1000
Message-ID: <B%Zba.2333$LT.7189@newsfeeds.bigpond.com>

"Yun Guan" <yguan_at_houston.rr.com> wrote in message news:mTTba.25149$mv.1105968_at_twister.austin.rr.com...
> I need to alter the default initial and next extent storage of a
tablespace.
> Is there an Oracle standard method to rebuild a tablespace?
>

Hi Allen,

It depends on the version of Oracle and the contents of the tablespace on what your options are.

But I would suggest moving to Locally Managed Tablespaces rather than changing the default storage parameters.

Cheers

Richard Received on Thu Mar 13 2003 - 06:55:44 CST