We help IT Professionals succeed at work.

Dictionary managed tablespaces in 10g?

cdion
cdion asked
on
719 Views
Last Modified: 2013-12-19
Is it no longer possible to create a dictionary managed tablespace in 10g?
Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
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?

Commented:
i'm affraid it mut be re-created ... whole database

Author

Commented:
Thanks for your help!

Author

Commented:
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?
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.