Oracle10g CREATE DATABASE creates system tablespace as dictionary managed by default.
Date: Thu, 16 Oct 2008 08:38:03 -0500
Message-ID: <785A4E1EF4D9E745BAC909B7941BEC009BEA63@usplm201.amer.corp.eds.com>
Hi All,
This is more of a comment than a question. Due to somenetwork problems I was unable to use the DBCA, so I was stuck creating a database manually. This is a 10.2.0.3 installation, and I've done it a few times on 8i and 9i, but never before on a 10g. This is the script I used to create the database. The weird thing is that with this script, in which I DO NOT specify locally managed for either system nor sysaux, the RDBMS created the SYSAUX tablespace as LOCALLY MANAGED and the SYSTEM tablespace as DICTIONARY MANAGED. Has anyone ever come across something like this before? I thought that 10g created tablespaces as locally managed by default (and it actually does... except for system aparently)
SQL> create database orc
logfile group 1 ('/u01/app/oracle/oradata/orc/redo1.log') size 100M, group 2 ('/u01/app/oracle/oradata/orc/redo2.log') size 100M, group 3 ('/u01/app/oracle/oradata/orc/redo3.log') size 100M character set WE8ISO8859P1
national character set utf8
datafile '/u01/app/oracle/oradata/orc/system.dbf'
size 500M autoextend off sysaux datafile '/u01/app/oracle/oradata/orc/sysaux.dbf' size 100M autoextend off undo tablespace undo datafile '/u01/app/oracle/oradata/orc/undo.dbf' size 10M default temporary tablespace temp tempfile '/u01/app/oracle/oradata/orc/temp.dbf' size 10M;
SQL> @?/rdbms/admin/catalog.sql
SQL> @?/rdbms/admin/catproc.sql
$emca -config dbcontrol db -repos create
SQL> select tablespace_name,extent_management from dba_tablespaces;
TABLESPACE_NAME EXTENT_MAN ------------------------------ ---------- SYSTEM DICTIONARY UNDO LOCAL SYSAUX LOCAL TEMP LOCAL
4 rows selected.
SQL> Regards
Guillermo Alan Bort
DBA / DBA Main Team
EDS, an HP company
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 16 2008 - 08:38:03 CDT