RE: System tablespace Oracle 9202

Actually, I think the reason it's not default is because we don't introduce something as a new default (generally!) without giving you a release notice e.g. in reverse, we warned people more than one release beforehand that SVRMGRL would be removed.

Pete
"Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA  

-----Original Message-----
Egan
Sent: Thursday, March 06, 2003 1:59 PM
To: Multiple recipients of list ORACLE-L

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


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pete Sharman
  INET: peter.sharman_at_oracle.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).