My Oracle Support Banner

Create/Upgrade/Migrate a Database to Have a Locally Managed SYSTEM Tablespace in 9.2 (Doc ID 175434.1)

Last updated on APRIL 29, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 and later
Information in this document applies to any platform.

Purpose

 

The bulletin explains how to have the SYSTEM tablespace as locally managed :

   --> during the creation of a new database in 9.2
   --> when the SYSTEM tablespace is already DICTIONARY managed in 9.2 
   --> during the upgrade of 7.3 , 8.0, 8.1 and 9.0 databases

   Note: The Oracle 8i Concepts Guide (p.3-8) states that you can create a 
         locally managed SYSTEM tablespace in the CREATE DATABASE command.

         Locally managed SYSTEM tablespaces are simply not possible until 9.2.

         Adding the EXTENT MANAGEMENT LOCAL clause in the CREATE DATABASE 
         command results in --> 8.1.5, in a syntax error or ORA-600 [3810] error  
                            --> 8.1.6, in ignoring the clause 
                            --> 8.1.7, in an ORA-2165

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.