dict-managed transform into localy-managed tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: dict-managed transform into localy-managed tablespace

Hybrid View

  1. #1
    Join Date
    Nov 2000
    Posts
    440
    I have a dictionary-managed tablespace with a pctincrease of 50.
    It is actualy 500M.

    If i transform a dictionnary-managed tablespace into a localy-manage tablespace with uniform extent of 128k
    using the dbms_space_admin package. Will my tablespace be smaller?

  2. #2
    Join Date
    Mar 2002
    Posts
    301
    Hi,

    When u convert into a LMT fragmentation is avoided. So, previously if ur DMT is heavily fragmented
    then you will see more amount of free space in your tablespace.

    Since Oracle maintains all the information about LMT in the header of the datafile itself, overhead is avoided.

    Vijay.
    Say No To Plastics

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