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" <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] "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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
