Re: storage parameters in create tabelspace

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 26 Aug 2001 22:14:04 +0200
Message-ID: <toirmm4cgjqe29@news.demon.nl>

"Dino Hsu" <dino1_at_ms1.hinet.net> wrote in message news:i44iotgl2bjc372ndvfope566u8si6s1t8_at_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
>

Yes they can.
Look into the dbms_space_admin package for conversion to LMT and vice versa.

Hth,
Sybrand Bakker, Senior Oracle DBA Received on Sun Aug 26 2001 - 15:14:04 CDT