Tablespace Management
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Tablespace Management

  1. #1
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245

    Tablespace Management

    In oracle 8i default tablespace management is dictionary.my question is can we change the dictionary managed tablespace to localy managed.If yes how because (alter storage options dont work on objects which are on dictionary managed tablespace) so i want to change it to locally managed.Can we do it.

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  3. #3
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    you can migrate from a DMT to an LMT - but you lose some benefits that way. If you can you would want to create new LMT's and move objects across to get all the benefits

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width