Re: System tablespace Oracle 9202

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Thu, 06 Mar 2003 16:43:48 -0800
Message-ID: <F001.00562B6F.20030306164348@fatcity.com>

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).

Received on Thu Mar 06 2003 - 18:43:48 CST