RE: System Tablespace Extent Management
- From: "Dave Phillips" <dphillips@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 8 Apr 2004 09:02:40 -0400
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@xxxxxxxxxxxxxxxxx]=20
Sent: Thursday, April 08, 2004 8:52 AM
To: oracle-l@xxxxxxxxxxxxx
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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
