Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Dictionary managed tablespaces in 10g?

Posted on 2007-10-09
5
Medium Priority
?
707 Views
Last Modified: 2013-12-19
Is it no longer possible to create a dictionary managed tablespace in 10g?
0
Comment
Question by:cdion
  • 3
  • 2
5 Comments
 
LVL 9

Accepted Solution

by:
konektor earned 200 total points
ID: 20042531
yes ... if system tablespace is dictionary managed too.

http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_7003.htm#i2231734

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

Author Comment

by:cdion
ID: 20042656
Great, thanks! Do you know if it's possible to alter the system tablespace to be dictionary managed if it has already been created as locally managed? Or will it need to be re-created?
0
 
LVL 9

Expert Comment

by:konektor
ID: 20042832
i'm affraid it mut be re-created ... whole database
0
 

Author Comment

by:cdion
ID: 20042877
Thanks for your help!
0
 

Author Comment

by:cdion
ID: 20042965
One more question for you. In order to specify Dictionary managed for the system tablespace, will I have to use my own script or is there an option using the Oracle tools?
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question