RE: System Tablespace Extent Management

From: EPS - DBA (Group) <dbamail_at_police.edmonton.ab.ca>
Date: Thu, 8 Apr 2004 06:58:33 -0600
Message-ID: <10AA67C37F89FF41833762DBD1D2B61106B305CE@qe02.police.edmonton.ab.ca>

This is what was created for my default 9.2.0.1 on Windows:

SQL> CREATE DATABASE xxx
  2 MAXINSTANCES 1
  3 MAXLOGHISTORY 1
  4 MAXLOGFILES 5
  5 MAXLOGMEMBERS 3
  6 MAXDATAFILES 100
  7 DATAFILE 'e:\ORACLE\oradata\cad\system_01.dbf' SIZE 300M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED
  8 EXTENT MANAGEMENT LOCAL
-----Original Message-----

From: Mercadante, Thomas F [mailto:thomas.mercadante_at_labor.state.ny.us] Sent: Thursday, April 08, 2004 6: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.

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://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_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Thu Apr 08 2004 - 07:55:07 CDT