I used DBMS_REDEFINITION.REDEF_TABLE procedure to move partition table from
one tablespace to another online. It moved the table itself to new
tablespace, but local indexes remained in old tablespace after procedure
completed.
Am I missing configuration parameter or procedure is not supposed to move
local and global indexes as well as oracle doc suggests?
We are using Oracle 12.1.0.1 upgraded from version 10g
EXEC
BEGIN
DBMS_REDEFINITION.REDEF_TABLE(
uname => 'TAGANALYSIS',
tname => 'SITEMON_PHP_SMTP_VK',
table_part_tablespace => 'SITEMONTBS',
index_tablespace => 'SITEMONTBS'
);
EXCEPTION
WHEN OTHERS THEN
DBMS_OUTPUT.PUT_LINE('SITEMON_PHP_SMTP_VK' || SQLCODE || ' - ' || SQLERRM);
END;
/
Thanks so much in advance,
Vadim
