thanks all. looks like it's system managed. Tom Mercadante Oracle Certified Professional -----Original Message----- From: Dave Phillips [mailto:dphillips@xxxxxxxxxxxxxxx] Sent: Thursday, April 08, 2004 9:03 AM To: oracle-l@xxxxxxxxxxxxx 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@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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------