Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: storage parameters in create tabelspace
"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