Re: storage parameters in create tabelspace

From: Dino Hsu <dino1_at_ms1.hinet.net>
Date: Sun, 26 Aug 2001 23:08:53 +0800
Message-ID: <i44iotgl2bjc372ndvfope566u8si6s1t8@4ax.com>

On Sun, 26 Aug 2001 14:55:04 GMT, "Van Messner" <vmessner_at_bestweb.net> wrote:

>You didn't say what version of Oracle you are using. But since you are
>going to rebuild all the indexes and create a new tablespace anyway, you
>might take a look at locally managed tablespaces (with autoallocate or fixed
>as appropriate) if you are using 8i.
>
>snip

The database was created in 8.0.5, later upgraded to 8.1.7. All tablespaces are managed by dictionary right now, I wonder whether tablespace management type can be changed without dropping the tablespaces.

Dino Received on Sun Aug 26 2001 - 10:08:53 CDT