RE: System tablespace Oracle 9202

[Pete Sharman]

Title: Message

Only if you use DBCA, I believe.

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-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Godlewski, Melissa
Sent: Thursday, March 06, 2003 12:49 PM
To: Multiple recipients of list ORACLE-L
Subject: System tablespace Oracle 9202

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