Re: Oracle 10g Temporary Tablespace OCA Question
Date: Wed, 29 Oct 2008 06:01:17 -0700 (PDT)
On Oct 29, 6:37 am, "ManFis" <man..._at_t-online.de> wrote:
> 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