Re: Is it possible to create a System tablespace with Local managed extent?
Date: Sat, 10 Mar 2001 15:26:53 GMT
Message-ID: <1Jrq6.13164$zV3.1205087_at_news1.frmt1.sfba.home.com>
According to "ORACLE8i DBA Handbook" on page 589,
"In the case of SYSTEM tablespace, you can declare the extent management
as 'local' in the 'create database' statement. If you create the SYSTEM
tablespace
It would have been nice if they had shown an example of the 'create
database'
as locally managed, all of the rollback segments must be created in a
locally
managed tablespace. However, any of the other tablespaces in the database
can have dictionary-managed extents. The use of local extent management
with a specification for local size can ensure that space within the
tablespace
is reused effectively."
syntax for doing this but I imagine that can be easily found in an Oracle
SQL
book.
Mike Received on Sat Mar 10 2001 - 16:26:53 CET