| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: System Tablespace Extent Management
thanks all. looks like it's system managed.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Dave Phillips [mailto:dphillips_at_gasper-corp.com]
Sent: Thursday, April 08, 2004 9:03 AM
To: oracle-l_at_freelists.org
Subject: RE: System Tablespace Extent Management
Here is the result using the 'New Database' template and generationg
scripts.
Oracle 9.2.04
Windows2000
CREATE DATABASE test
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE 'C:\oracle\oradata\test\system01.dbf' SIZE 250M REUSE
AUTOEXTEND ON NEXT 10240K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE
'C:\oracle\oradata\test\temp01.dbf' SIZE 40M REUSE AUTOEXTEND ON NEXT
640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE
'C:\oracle\oradata\test\undotbs01.dbf' SIZE 200M REUSE AUTOEXTEND ON
NEXT 5120K MAXSIZE UNLIMITED
CHARACTER SET WE8MSWIN1252
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('C:\oracle\oradata\test\redo01.log') SIZE 102400K,
GROUP 2 ('C:\oracle\oradata\test\redo02.log') SIZE 102400K,
GROUP 3 ('C:\oracle\oradata\test\redo03.log') SIZE 102400K;
HTH
David Phillips
Support DBA
Gasper Division
NCR
-----Original Message-----
From: Mercadante, Thomas F [mailto:thomas.mercadante_at_labor.state.ny.us]=20
Sent: Thursday, April 08, 2004 8:52 AM
To: oracle-l_at_freelists.org
Subject: System Tablespace Extent Management
All,
I am creating a new 9i database and want to create the system tablespace with local extent management. I don't have access to dbca, so I can't generate any scripts. =20
Can someone see what dbca uses for sizing settings in the system
tablespace
for me? Does it use uniform or system managed? If it uses uniform, can
you
let me know what settings it uses?
thanks
Tom Mercadante
Oracle Certified Professional
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |