8 Replies Latest reply: Dec 2, 2010 3:15 AM by 763539 RSS

    Move version enabled table indexes to a custom tablespace


      Is there any way to move the _PKI$ index of an existing version enabled table to another tablespace?
      I have tried that:

      alter index MYTABLE_PKI$ rebuild tablespace NEW_TABLESPACE;

      It did not work, because I'm not allowed to alter a veresion enabled table.

      My other try was altering the MYTABLE_LTS after dbms_wm.beginddl('MYTABLE'), but I couldn't see the PKI$ index on the LTS table.

      The WM version is

      Thanks in advance,