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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Is it possible to create a System tablespace with Local managed extent?

From: Mike Moore <hicamel_at_mail.home.com>
Date: Sat, 10 Mar 2001 15:26:53 GMT
Message-ID: <1Jrq6.13164$zV3.1205087@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
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."

It would have been nice if they had shown an example of the 'create database'
syntax for doing this but I imagine that can be easily found in an Oracle SQL
book.

Mike Received on Sat Mar 10 2001 - 09:26:53 CST