Re: Is it possible to create a System tablespace with Local managed extent?
Date: Mon, 12 Mar 2001 22:54:18 -0800
Message-ID: <3AADC41A.6C128381_at_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
The truth however, is that neither Oracle version 8.1.5 OR 8.1.6
supports
the concept of a locally managed system tablespace.
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 - 07:54:18 CET