Oracle, Oracle DB, 10.2, how to create dictionary managed database.

Oracle 10.2 currently sets all databases to locally managed rather than dictionary managed.  I am needing to setup a dictionary managed database.  
SHSUFLIGHTAsked:
Who is Participating?
 
johnsoneSenior Oracle DBACommented:
Not sure, I don't use dbca to create databases.  I do it manually.

You can use dbca to create the scripts and then you should be able to modify the create database statement to specify dictionary managed before running it.
0
 
johnsoneSenior Oracle DBACommented:
I am assuming that Oracle 10 is the same as Oracle 9 and that in order to create a dictionary managed tablespace, the SYSTEM tablespace needs to be dictionary managed.

select extent_management from dba_tablespaces where tablespace_name = 'SYSTEM';

When creating a tablespace you need to specify EXTENT MANAGEMENT DICTIONARY to create a dictionary managed tablespace.
0
 
johnsoneSenior Oracle DBACommented:
This is from the Oracle 10 manual:


You cannot specify DICTIONARY if the SYSTEM tablespace of the database is locally managed or if you have specified the temporary_tablespace_clause.

Note:
Oracle strongly recommends that you create only locally managed tablespaces. Locally managed tablespaces are much more efficiently managed than dictionary-managed tablespaces. The creation of new dictionary-managed tablespaces is scheduled for desupport.
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
SHSUFLIGHTAuthor Commented:
Yes, we are aware of that however vendor requirements are currently Dictionary Managed!  How can you create the DB w/ dicitionary Managed?
0
 
johnsoneSenior Oracle DBACommented:
When creating the database you need to specify EXTENT MANAGEMENT DICTIONARY for the SYSTEM tablespace in the CREATE DATABASE statement.
0
 
SHSUFLIGHTAuthor Commented:
Is there any other way to accomplish this other than manually?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.