[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1251
  • Last Modified:

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.  
0
SHSUFLIGHT
Asked:
SHSUFLIGHT
  • 4
  • 2
1 Solution
 
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
 
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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
 
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now