Re: Oracle 10g Temporary Tablespace OCA Question

From: Mark D Powell <>
Date: Fri, 31 Oct 2008 13:48:47 -0700 (PDT)
Message-ID: <>

On Oct 29, 5:42 pm, Palooka <> wrote:
> Mark D Powell wrote:
> > 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.
> Surely that is the right answer to the exam question.
> In real life though, it is difficult to imagine any 10g scenario where a
> database is created without a default temporary tablespace (consisting
> of tempfiles), nor for that matter one where the system tablespace is
> not locally managed. So IMHO the question is an entirely silly and
> pointless one (not criticising OP here; criticising Oracle's exams).
> Palooka- Hide quoted text -
> - Show quoted text -

At least in the past it was possible using a manual create database statement to create the database without a temp tablespace and to add the temporary tablespace using a create tablespace statement after the create database command completed.

We in fact did it that way. Create database. Create temporary tablespace. Create rollback tablespace, create user and data tablespaces ... All steps were done as separate commands.

HTH -- Mark D Powell -- Received on Fri Oct 31 2008 - 15:48:47 CDT

Original text of this message