Re: Oracle 10g Temporary Tablespace OCA Question

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Wed, 29 Oct 2008 06:01:17 -0700 (PDT)
Message-ID: <a8b92864-7ae6-4169-8d62-db8954a6b764@t41g2000hsc.googlegroups.com>

On Oct 29, 6:37�am, "ManFis" <man..._at_t-online.de> 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

This message: [ Message body ]
Next message: ddf: "Re: Oracle Left Outer Join problem - first occurance of a match"
Previous message: Connor McDonald: "Re: 11g or not to 11g ?"
In reply to: ManFis: "Oracle 10g Temporary Tablespace OCA Question"
Next in thread: Palooka: "Re: Oracle 10g Temporary Tablespace OCA Question"
Reply: Palooka: "Re: Oracle 10g Temporary Tablespace OCA Question"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message