Re: Oracle Myths

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 12 Jun 2002 09:31:30 +0100
Message-ID: <1023870645.5222.0.nnrp-12.9e984b29@news.demon.co.uk>

I've now got my 9.2 installed - and have just enough space left to create a couple of database ;)

You are quite right - the SYSTEM tablespace can be dictionary managed, and once you
have a dictionary managed SYSTEM, you can create other tablespaces as dictionary managed as well.

I think the problem is that everyone's first install is probably going to be through the OUI tools, and DBCA automatically injects the line

    EXTENT MANAGEMENT LOCAL
into the script to create the database.

Example:

create database d922

        ...  bits about max instances etc.
        datafile '/u02/app/oracle/oradata/D922/system01.dbf'
                size 100M reuse
                autoextend on next  10240K maxsize unlimited
                extent management local

default temporary tablespace temp

    .... etc.

In the absence of the EXTENT MANAGEMENT LOCAL, the SYSTEM tablespace is created dictionary managed.

Thanks for highlighting that one - it would have been very easy to miss.

And thanks for the comment on the book.

Regards

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminars
        UK            June / July
        Australia      July / August
http://www.jlcomp.demon.co.uk/seminar.html

Vladimir Begun wrote in message <3D06647B.C565F4B5_at_oracle.com>...


>Jonathan

>

>compatible=9.2.0.0.0, again it's not a production or whatever

>database I just planned to do some other testing and created

>it like that.

>

>The original question of Howard was how to make "artificial"

>'create tablespace system'... I answered that it's possible

>to do it when you create a database. So, I do not want to

>tell that it's better to have it DICTIONARY managed, I just

>want to tell that it's possible to create it like that.

>

>Just curious, do you experience any problems when you create

>database like that?

>

>P.S.: Thanks for you book, it's very good one!!!

>

>Kind Regards,

>--

>Vladimir Begun

>The statements and opinions expressed here are my own and

>do not necessarily represent those of Oracle Corporation.

Received on Wed Jun 12 2002 - 03:31:30 CDT