RE: System tablespace Oracle 9202

[Balakrishnan, Ashok - VSCM]

Title: Message

In your create database script, make sure you have EXTENT MANAGEMENT LOCAL after the sysdate datafile clause.

Here's an example -

 

CREATE DATABASE abc
USER SYS IDENTIFIED BY xyz
USER SYSTEM IDENTIFIED BY xyz
DATAFILE '/u10/oradata/abc/system01.dbf' SIZE 350M REUSE
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/u20/oradata/abc/temp01.dbf' SIZE 8001M REUSE
UNDO TABLESPACE "UNDOTBS" DATAFILE '/u30/oradata/abc/undotbs01.dbf' SIZE 10230M REUSE
...........

-----Original Message-----
From: Pete Sharman [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 06, 2003 1:34 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: System tablespace Oracle 9202

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