RE: System tablespace Oracle 9202

From: Godlewski, Melissa <Melissa.Godlewski_at_hq.doe.gov>
Date: Fri, 07 Mar 2003 05:54:02 -0800
Message-ID: <F001.005631AC.20030307055402@fatcity.com>

This is a UNIX Solaris running 5.8 I created the database from sqlplus using scripts. I somehow thought the default was LMT for system rather then DICTIONARY. I changed the script to LMT and recreated, but I was surprised by the Dictionary system creation.

-----Original Message-----
Sent: Thursday, March 06, 2003 9:19 PM
To: Multiple recipients of list ORACLE-L

DBCA, by default in 92 will create SYSTEM as LMT. There is an option to do dictionary if you prefer. CREATE DATABASE default is a dictionary managed SYSTEM tablespace with LMT optioinal.

RF

-----Original Message-----
To: Multiple recipients of list ORACLE-L Sent: 3/6/2003 6:43 PM

What platform is this? I can't be sure (because my laptop is miles away at the moment) but I think on 9.2 on NT when I used the creation assistant to generate scripts for me, SYSTEM was an lmt.

hth
connor

• "Godlewski, Melissa" <Melissa.Godlewski_at_hq.doe.gov> wrote: > List,
  >
  > System tablespace for Oracle 9iR2 is defaulting to
  > Dictionary Extent
  > Management. I thought all tablespaces defaulted to
  > Local in this release.
  >
  >
  > Thu Mar 6 15:29:43 2003
  > create tablespace SYSTEM datafile
  > '/oradb/DEV/system/system01.dbf'
  > size 201M reuse
  > default storage (initial 10K next 10K) EXTENT
  > MANAGEMENT DICTIONARY online
  > Thu Mar 6 15:29:57 2003
  > Completed: create tablespace SYSTEM datafile
  > '/oradb/DEV
  > Thu Mar 6 15:29:57 2003
  > create rollback segment SYSTEM tablespace SYSTEM
  > storage (initial 50K next 50K)
  > Completed: create rollback segment SYSTEM tablespace
  > SYSTEM
  >
  >
  

  ---

Connor McDonald
web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"

---

Do You Yahoo!?
Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?iso-8859-1?q?Connor=20McDonald?=
  INET: hamcdc_at_yahoo.co.uk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Freeman Robert - IL
  INET: FREEMANR_at_tusc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Godlewski, Melissa
  INET: Melissa.Godlewski_at_hq.doe.gov

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Mar 07 2003 - 07:54:02 CST