Re: Dictionary vs Locally managed tablespace.

Hi Hyang Hwang,

Pro's : Better performance, less fragmentation and easier maintenance. Cons : Only provided with Oracle 8i and forward.

In fact, you should always choose locally managed tablespaces whenever possible.

You CAN in fact create a locally managed SYSTEM tablespace, but this requires all rollback segments of that database to be in uniform locally managed tablespaces (See Oracle 8i documentation for details).

• Kenneth Koenraadt plovmand_at_hotmail.com

HYANG HWANG <7215H_at_prodigy.net> skrev i meddelelsen <97k1hv$8gss$1_at_newssvr05-en0.news.prodigy.com>...
>Hi!
>Can someone explain pro and cons between dictionary and locally managed
>talespace.(When not to use locally managed tablespace other than system and
>rollback)
>
>
>thanks
>Young.
>rootyh_at_yahoo.com
>
>
Received on Thu Mar 01 2001 - 08:47:56 CST