Re: Is it possible to create a System tablespace with Local managed extent?

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Mon, 12 Mar 2001 22:54:18 -0800
Message-ID: <3AADC41A.6C128381@exesolutions.com>

Leaving aside the personal insults and ill-humor for a moment ... I know I too am occasionally guilty of having a short-temper or writing things in jest and not having them taken that way ... I wish to acknowledge that I made a mistake.

I took Oracle at its word that you could create a SYSTEM tablespace as locally managed and finally, today, got my hands on a server where I could put it to the test using version 8.1.7.

You can't. Oracle's statements to the contrary are incorrect.

And a search of METALINK substantiates this as follows:

Bookmark

                                                Fixed font

Go to End

Doc ID:

Note:112951.1
Subject:

Creating a Locally Managed System Tablespace Type:

BULLETIN
Status:

PUBLISHED

                                                  Content Type:

TEXT/PLAIN
                                                  Creation Date:

19-JUN-2000
                                                  Last Revision Date:

25-AUG-2000
                                                  Language:

USAENG PURPOSE

To address locally managed system tablespaces.

SCOPE & APPLICATION

Database Administrators, and Oracle Support employees.

CREATING A LOCALLY MANAGED SYSTEM TABLESPACE

The Oracle 8i Concepts guide page. 3-8, states that you can specify that
the system tablespace be created as locally managed by including the extent
management local clause in your create database script......It states as
follows:

"For the SYSTEM tablespace, you can specify EXTENT MANAGEMENT LOCAL in the
CREATE DATABASE command"

The truth however, is that neither Oracle version 8.1.5 OR 8.1.6 supports
the concept of a locally managed system tablespace.

In Oracle 8.1.5, any attempt to add the EXTENT MANAGEMENT LOCAL clause to
your create database command will result in a syntax error OR an ORA-600 [3810] error. In Oracle 8.1.6, any attempt to do so, results in
no error....But the clause is ignored.

Locally managed system tablespaces are simply not yet possible.

RELATED DOCUMENTS

[BUG:809225]
.

So now that we have solved that problem let me address another matter that has been reported.

That you must have a least one rollback segment in a dictionary managed tablespace before you can create rollback segments in a locally managed tablespace. On this one my test established that if this is the case, the rollback segment in the dictionary managed SYSTEM tablespace suffices. I had no problem creating a locally managed tablespace in 8.1.7 and then creating a number of rollback segments within it.

Daniel A. Morgan Received on Tue Mar 13 2001 - 00:54:18 CST