Re: Oracle 10g Temporary Tablespace OCA Question

From: Mark D Powell <>
Date: Wed, 29 Oct 2008 06:01:17 -0700 (PDT)
Message-ID: <>

On Oct 29, 6:37 am, "ManFis" <> wrote:
> Hello
> a OCA question!!!
> A system tablespace can have a dictionary management or a local management.
> is it true that in case of a local management of the SYSTEM tablespace the
> creation of a temporary tablespace is mandatory?

From the Oracle Administrators Guide Ch 2 Creating an Oracle Database Topic: Creating a Locally Managed SYSTEM Tablespace

When you create your database with a locally managed SYSTEM tablespace, ensure that the following conditions are met:

A default temporary tablespace must exist, and that tablespace cannot be the SYSTEM tablespace.

HTH -- Mark D Powell -- Received on Wed Oct 29 2008 - 08:01:17 CDT

Original text of this message