Re: System tablespace Oracle 9202

It was only in 9.2 that it was possible to create the system tablespace as locally managed, and rumour says that in 10i system tbs defaults to locally managed.

The reason it's not default in 9.2 is most likely because......:

1. Most likely they just didn't update the DBCA default scripts to use this feature when they went from 9i R1 to 9i R2 (read: the scripts was just copied from the 9i R1 source tree)
2. The feature is brand new, so if some problems turn up, most databases wont have it set, because they are created from the DBCA.

Regards,
Morten Egan

Godlewski, Melissa 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
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Morten Egan
  INET: meg_at_miracleas.dk

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