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