4 Replies Latest reply on Aug 26, 2014 2:04 PM by Laury

    Moving heterogenous segments to another tablespace




      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