4 Replies Latest reply: Aug 26, 2014 9:04 AM by Laury RSS

    Moving heterogenous segments to another tablespace

    Laury

      Hi,

       

      To perform some clean up, I need to move some segments (from 1-4 GB) from one tablespace to another tablespace and then back to the original tablespace.

      To avoid inter-dependencies, I intend to perform with this sequence:

      - tables

      - lobs

      - subpartition tables

      - indexes

      - partition tables

      - partition indexes

       

      When finish, rebuild online the unusable/invalid indexes.

       

      If you have such experience, can you tell me if it is a good approach?


      Thanks and Regards