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