DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2000
    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

    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.

    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.