This discussion is archived
8 Replies Latest reply: Dec 2, 2010 1:15 AM by 763539 RSS

Move version enabled table indexes to a custom tablespace

763539 Newbie
Currently Being Moderated
Hy!

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 11.1.0.7.0.

Thanks in advance,
Vityesz

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points