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 188.8.131.52.0.
Thanks in advance,
Good hint indeed, but sadly there is no parameter to set to change the tablespace.
Because I'm short on time, I think I will stick to temporaly disable the versioning of the tables, alter the indexes, and reenable them again.
You would want to use the DDL option of AlterVersionedTable in order to change the tablespace directly. This would allow you to change it without have to call disableversioning on the table.
Thanks, I've overlooked the DDL parameter in the manual, shame on me.
I tried to use it with force=true (doesn't work with false), but it ended up in a ORA-01418 error. I'm trying to alter the xxx_PKI$ index of the xxx_LT table. Is it something special with the _PKI$?
That should work.
Make sure that it isn't attempting to run a previous execution of the procedure. Check the all_wm_vt_errors view for any rows pertaining to the VIKTOR.TEST_VIKTOR table. If there are any, you would need to call the procedure with the ignore_last_error parameter set to true. This should remove the row from all_wm_vt_errors, at which point you could execute it normally.