Re: locally managed tablespace

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sun, 24 Jun 2001 06:22:49 -0700
Message-ID: <3B35E9A9.4BCF1B66@exesolutions.com>

"m.mueller" wrote:

> Currently I'm studying space managment in tablespaces.
> I'm not quite sure if I understand the concept ( my questiom may sound
> very basic).
> Locally managed tablespaces offers o lot of advantages, compared to the
> default dictionary managed method.
> Furthermore since Oracle 8.1 I'm able to create a Database with a
> locally managed SYSTEM tablespace, not only some tablesspaces (eg DATA),
> if I correctly understand the Administrator's Guide.
> Are there any reasons (advantages) in dictionary managed tablespaces if
> I don't have to worry about backward compatabilities? (revert to a
> Oracle version prior 8.1)
> Any suggestions are welcome.
> Thank's a lot and have a nice day
>
> Manuela Mueller

You can not crate a locally managed SYSTEM tablespace. Granted the docs on technet say that ... but it is not possible.

Threre are no known advantages to dictionary managed tablespaces except the single case, above, where one is still mandatory.

Backward compatibility is not an issue.

Daniel A. Morgan Received on Sun Jun 24 2001 - 08:22:49 CDT