DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006

    using package sys.dbms_space_admin .tablespace_migrate_to_local('USERS')

    there is a package sys.dbms_space_admin .tablespace_migrate_to_local('USERS') that we can use to move from dictionary to local tablespaces. Will it also remove the HWM when you use this package, I know if you build a new local tablespaces and rebuild the objects, it will remove the HWM and I am not sure about this package. also will it help to reduce the spaces?

    Please advise.


  2. #2
    Join Date
    Nov 2000
    Pittsburgh, PA
    It will change the tablespace to locally managed without resizing, reorginizing or moving any othe the currently allocated extents. If you want to shrink a tablespace you need to look to see what is on the upper end of the tablespace.
    this space intentionally left blank

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